
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 |
|
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 |
Database Administration, DBM Operators, Database System Administrator
Database Manager CLI, Managing Database Manager Operators
Database Administration in CCMS, User Data, DBM Operator
Database Studio, Managing Users: Overview
SAP MaxDB Security Guide, User Administration and Authentication, Authorizations