Background documentationDBM Operators Locate this document in the navigation structure

 

DBM operators manage databases. When a database is created, an initial DBM operator is created who has the required DBM operator properties and all server authorizations. The default value for the name of the first DBM operator is DBM. The database system administrator also has all DBM operator authorizations.

Note that DBM operators are not database users. They can neither change data in the database nor log on to query tools or the Loader.

Properties
DBM Operator Properties

Property

Description

Disabled

Specifies whether the user account of the DBM operator is locked

Enable Second Password

You can also define a second password. This way you can temporarily allow other people to work with the DBM operator account (for example, for support purposes) without the DBM operator having to reveal or change the original password.

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

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

Managing DBM Operators

If DBM operators have the required DBM server permissions, they can create other DBM operators, change DBM operator properties and DBM server permissions of other DBM operators, or delete other DBM operators.

If you change the name or properties of another DBM operator or delete it while this operator is logged on to Database Manager using a different DBM server process, the change or deletion does not become effective within this DBM server session. Only when this operator logs on again to Database Manager, the new name or property definition becomes effective. If the operator was deleted, it cannot log on to Database Manager any more.

You have the following options for displaying and managing DBM operators: