The database system administrator (also called SYSDBA) is the first user that you create when creating the database. There can only be one database system administrator per database.
The database system administrator is the user with the most authorizations in the database. The database system administrator 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 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.
The database system administrator has all the DBM server permissions that a DBM operator can have. The database system administrator can manage databases.
The default name of the database system administrator is DBADMIN, in SAP systems SUPERDBA.
Properties
SQL User Properties |
Description |
---|---|
Database User Class |
Database user class (user mode 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. |
DBM server permissions (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 |
Managing the event dispatcher |
Yes |
EvtDispMgm |
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 |
Managing the Database System Administrator
You can use Database Manager CLI or a query tool to manage the database system administrator.
Database Manager CLI, Managing Database Manager Operators
SQL Reference Manual, Authorization
SAP MaxDB Security Guide, User Administration and Authentication, Authorizations
SAP note 1542818