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.
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. |
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 |
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:
Database Studio, DBM Operators: Creating, Editing and Deleting
Database Manager CLI Tutorial, Creating DBM Operators
Database Administration in CCMS, User Data