user_put

You can change the properties and server permissions of any DBM operator. This includes the name of the currently logged on DBM operator, as well as the data of the first DBM operator and the database system administrator.

If you change the properties of another DBM operator while this operator is logged on to Database Manager using a different DBM server process, the change does not become effective within that DBM server session. Only when this operator logs on again to Database Manager, the new property definition becomes effective.

Note Note

The database system automatically converts passwords for DBM operators into upper-case letters.

End of the note.

Prerequisites

You have the server permission UserMgm.
If you want to change the password of the database system administrator, the database must be in the ONLINE operational state.

Structure

user_put <dbm_operator> <property_definition>

<property_definition> :: = <property_spec> | <property_spec_list>

<property_spec> :: = <property>=<value>

<property_spec_list> :: = <property>=<value_list>

<value_list> :: = <property>=<value,value,...>

Options
Option	Description
`<dbm_operator>`	Name of a DBM operator or database system administrator whose properties are to be changed
`<property>`	Property of the operator Possible values are: `PASSWORD \| COMMENT \| SECONDPASSWORD \| DISABLED \| SERVERRIGHTS` `PASSWORD`: operator password `COMMENT`: description `SECONDPASSWORD`: second operator password `DISABLED`: operator blocked `SERVERRIGHTS`: server permission
`<value>`	Value of the DBM operator property allocated Values for properties: `PASSWORD`, `COMMENT` and `SECONDPASSWORD`: can be freely defined. Possible values for the `DISABLED` property: `YES \| NO` `YES`: The operator is locked. `NO`: The operator is not locked. Possible values for the `SERVERRIGHTS` property: see Glossary, Server Permission Put a plus sign before the server permission to assign it and a minus sign to revoke it. If you specify more than one server permission, separate them with commas.

Result

OK

In the event of errors, see Reply Format.

Example

Call Database Manager CLI, log on as the operator OLEG with the password MONDAY, connect to the database DEMODB,

change the password for the DBM operator ELENA to the value SATURDAY, assign the server permission to start databases and revoke the server permission to stop databases:

>dbmcli –u OLEG,MONDAY –d DEMODB user_put ELENA PASSWORD=SATURDAY SERVERRIGHTS=+DBStart,-DBStop

OK

More Information

Glossary, Server Permission

Database Administration, DBM Operators, Database Users