Procedure documentationCreating a DBM Operator Locate this document in the navigation structure

 

You can create a new DBM operator based on an existing DBM operator. The server permissions and DBM operator properties of the existing DBM operator, with the exception of the name and password, are copied to the new one. You can then adjust these server authorizations and DBM operator properties to fit your requirements.

You can also simply define a name and password when you create a new DBM operator. The DBM operator is then created with only these two DBM properties. Subsequently you must explicitly assign all additional DBM operator properties and server permissions to the operator.

Prerequisites

You can find the prerequisites under Database Manager CLI, user_create

Procedure

Scenario 1

You want to create the new DBM operator OLEG with password MONDAY. You use the configuration of the database system administrator as a template for the new DBM operator and then change this configuration, revoking the following operator's permissions:

  • starting and stopping databases

  • executing operating system commands

  • managing the installation

  • managing DBM operators

Procedure

  1. Call Database Manager CLI in session mode, log on as database system administrator DBADMIN with password SECRET, and connect to database DEMODB:

    >dbmcli -u DBADMIN,SECRET -d DEMODB

    dbmcli on DEMODB>

  2. Create the Database Manager operator OLEG with password MONDAY and the server permissions of database system administrator DBADMIN:

    dbmcli on DEMODB>user_create OLEG,MONDAY DBADMIN

    OK

  3. Change the DBM operator properties according to the above scenario:

    dbmcli on DEMODB>user_put OLEG SERVERRIGHTS=-DBStart,-DBStop,-SystemCmd,-InstallMgm,-UserMgm

    OK

Result

You have created the DBM operator OLEG with password MONDAY for the database DEMODB. OLEG has the following server permissions: DBInfoRead, Backup, LoadSystab, Recovery, DBFileRead, ParamCheckWrite, ParamFull,ParamRead, AccessSQL, AccessUtility, SchedulerMgm and Scheduling.

Scenario 2

You want to create the new DBM operator ELENA with password SUNDAY and assign it the following server permissions:

  • Perform backups

  • Recover the database (import backups into the database)

  • Access database parameters (read and checked write)

  • Schedule DBM commands

Procedure

  1. Call Database Manager CLI in session mode, log on as database system administrator DBADMIN with password SECRET, and connect to database DEMODB:

    >dbmcli DBADMIN,SECRET DEMODB

    dbmcli on DEMODB>

  2. Create the DBM operator ELENA with password SUNDAY:

    dbmcli on DEMODB>user_create ELENA,SUNDAY

    OK

  3. Assign the server permissions according to the above scenario:

    dbmcli on DEMODB>user_put ELENA SERVERRIGHTS=+Backup,+Recovery,+ParamCheckWrite,+Scheduling

    OK

Result

You have created the DBM operator ELENA with password SUNDAY for the database DEMODB. ELENA has the following server permissions: Backup, Recovery, ParamCheckwrite and Scheduling.

More Information

Glossary, Server Permission

Database Administration, DBM Operators