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.
You can find the prerequisites under Database Manager CLI, user_create
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
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>
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
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.
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
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>
Create the DBM operator ELENA with password SUNDAY:
dbmcli on DEMODB>user_create ELENA,SUNDAY
OK
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.