DBA

Database administrators

Creation of RESOURCE and STANDARD database users

Definition of database objects

Granting of all or part of privileges for these database objects to other database users

RESOURCE

Definition of data and database procedures

Granting of privileges for these database objects to other database users

STANDARD

Access to data and database procedures that were defined by other database users and for which the user has been granted privileges

Definition of view tables, synonyms and temporary tables

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