The database system administrator (SYSDBA user) is the initial database user. You create this user when you install the database instance. The SYSDBA user can then use the query tools to define other database users or user groups with the SQL statements for user authorization. This user can define data and database procedures and grant other database users privileges for these database objects.
The SYSDBA user also has the following properties:
· The SYSDBA user is the owner of system tables. When system tables are uploaded, the upload tool logs on to the database instance as SYSDBA.
· The SYSDBA user is the only database user who also has the authorizations of a Database Manager operator.
Note that the Database Manager always converts all letters to uppercase letters automatically. For this reason, always specify the user name and password of the SYSDBA user in uppercase letters.
The SYSDBA user’s password can still be changed once the database registration has been completed.