The database system administrator (also called SYSDBA) has all the authorizations that a database user of the DBA database user class can have, plus the following properties:
The database system administrator is the owner of several system tables.
When a database tool loads the system tables, it logs on to the database as database system administrator.
The database system administrator has all the server authorizations that a DBM operator can have. The database system administrator can manage databases.
The database system administrator has owner rights over all database users. The database system administrator can create database users of any database user class and can also create DBM operators.
SQL User Properties |
Description |
---|---|
User Class |
Database user class (SYSDBA) |
Connection Mode |
NOT EXCLUSIVE: Allows the database system administrator to open several database sessions simultaneously EXCLUSIVE: Prevents the database system administrator from opening database sessions simultaneously |
Session Timeout |
Length of time after which the database session is ended if the database system administrator is inactive |
Cost Warning |
Specifies the estimated SELECT cost value beyond which the user receives a warning. If a warning is issued, the user is asked whether he or she really wants to execute the SQL statement. |
Cost Limit |
Specifies the estimated SELECT cost value beyond which the SQL statement is not executed. This value must be greater than the Cost Warning value. |
Default Code |
DEFAULT: The default value for the code attribute is defined by the database parameter DefaultCodePage. ASCII: The default value for the code attribute is ASCII. UNICODE: The default value for the code attribute is Unicode. |
Property |
Description |
---|---|
Disabled |
Specifies whether the user account of the database system administrator is locked |
Enable Second Password |
You can define a second password for the database system administrator. This way you can temporarily allow other people to work with the database system administrator (for example, for support purposes) without the database system administrator having to reveal or change the original password. |
Server authorizations (Server Rights) are authorizations for the DBM server program and hence for managing databases.
Permission |
Required for Logon to a Database with Database Studio |
Name in Database Manager CLI |
---|---|---|
Accessing an SQL session |
Yes |
AccessSQL |
Access to Utility sessions |
- |
AccessUtility |
Executing backups |
- |
Backup |
Accessing database files (reading only) |
Yes |
DBFileRead |
Displaying status information |
Yes |
DBInfoRead |
Starting the database |
- |
DBStart |
Stopping the database |
- |
DBStop |
Using the Loader program |
- |
ExecLoad |
Installation management |
- |
InstallMgm |
Loading the system tables |
- |
LoadSysTab |
Accessing database parameters (reading and writing; only those commands for changing parameters may be executed whose changes are checked against the default parameter file cserv.pcf) |
- |
ParamCheckWrite |
Accessing database parameters (reading and writing; all commands can be executed, even those for directly changing the parameter file without the changes being checked by the system) |
- |
ParamFull |
Accessing database parameters (reading only) |
Yes |
ParamRead |
Restoring databases |
- |
Recovery |
Managing the scheduler |
- |
SchedulerMgm |
Scheduling DBM commands |
- |
Scheduling |
Managing the shared memory |
- |
SharedMemoryAdmin |
Executing operating system commands |
- |
SystemCmd |
Managing DBM operators |
- |
UserMgm |
The database system administrator is the first database user you create when creating the database. The default value for the name of the database system administrator is DBADMIN.
You can use Database Studio, Database Manager CLI or a query tool to display or change the SQL user properties, DBM operator properties and DBM server permissions of the database system administrator.
Database Studio, DBM Operators: Creating, Editing and Deleting
Database Manager CLI, user_get, user_getrights, user_put
SQL Reference Manual, ALTER USER Statement, ALTER PASSWORD Statement