Show TOC

Server PermissionLocate this document in the navigation structure

Use

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.

Table 1: DBM Server Permissions

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

More Information