To execute DBM commands in the Database Manager, Database Manager Operators (DBM operators) and the Database System Administrator (SYSDBA user) require the corresponding authorizations for the DBM Server. These authorizations are called server authorizations and are stored in the Database Manager as the DBM operator property Server Rights. A server authorization may cover more than one DBM command and one DBM command may have more than one server authorization assigned to it.
Server Authorizations
Authorization |
ID in the Database Manager GUI |
ID in the Database Manager CLI |
Accessing SQL sessions |
Access to SQL session |
AccessSQL |
Accessing a utility session |
Access to utility session |
AccessUtility |
Executing backups |
Saving backups |
Backup |
Accessing database files (read-only) |
Database file access (read only) |
DBFileRead |
Display status information |
Request status data |
DBInfoRead |
Starting the database instance |
Start database instance |
DBStart |
Stopping the database instance |
Stop database instance |
DBStop |
Running the Loader program |
Execute the LOAD program |
ExecLoad |
Managing installation |
Installation management |
InstallMgm |
Load the system tables |
Load the system tables |
LoadSysTab |
Accessing database parameters (reading and writing; only those commands for changing parameters may be executed whose changes are checked with the default parameter file cserv.pcf) |
Parameter access (checked write) |
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) |
Parameter access (read and write) |
ParamFull |
Accessing database parameters (read-only) |
Parameter access (read only) |
ParamRead |
Restoring backups |
Restoring backups |
Recovery |
Managing the scheduler |
- |
SchedulerMgm |
Schedule DBM commands |
- |
Scheduling |
Managing the shared memory |
|
SharedMemoryAdmin |
Executing operating system commands |
Execute operating system commands |
SystemCmd |
Managing DBM operators |
User management |
UserMgm |
See also:
Users, Authentication and Authorizations
Database Manager GUI, Changing Server Authorizations, Changing the Server Authorizations of the Database System Administrator