Server Authorizations for the DBM Server

Use

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