The database administrator (SYSDBA user) is the first database user. The user is created when a new database instance is created:
· If you create the database instance with the Database Manager CLI, then the SYSDBA user is created when the database instance is activated.
· If you create the database instance with the Database Manager GUI, then the SYSDBA user is created when the database instance is created.
The system default for the name of the SYSDBA user is dba.
Note the conventions for user names and passwords.
Only change the password for the SYSDBA user with the Database Manager (not with the SQL statement ALTER PASSWORD). See Database Manager GUI, Changing a Database User’s Password or Database Manager CLI, Changing the DBM Operator Data.
The SYSDBA user has all rights that a database user can have, and also the following properties:
· The SYSDBA user is the owner of a few system tables. When system tables are loaded, the load tool logs on to the database instance as the SYSDBA user.
· The SYSDBA user is the only database user who can log on to the Database Manager database tool, where he/she has the same rights as the first DBM operator. The data of the SYSDBA user is saved in the Database Manager and in the database instance.
See also:
Database Manager Operator (DBM Operator)