To execute DBM commands, DBM operators and the database system administrator require the corresponding permissions for the DBM server. These permissions are called server permissions. A server permission may cover more than one DBM command and one DBM command may have more than one server permission assigned to it.
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 |
Database Administration, Managing Users
Database Studio, DBM Operator: Creating, Editing, and Deleting
Database Manager CLI, user_getrights, user_put