user_put

You can change the DBM operator properties and server authorizations of any DBM operator. This includes the name of the currently logged on DBM operator, 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 this DBM server session. Only when this operator logs on again to Database Manager, the new property definition becomes effective.

See Conventions for User Names and Passwords.

Note Note

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

End of the note.

Prerequisites

You have the server authorization UserMgm.
If you want to change the password of the database system administrator, the database instance 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 operator Possible values are: `PASSWORD \| COMMENT \| SECONDPASSWORD \| DISABLED \| SERVERRIGHTS` `PASSWORD`: Operator password `COMMENT`: Description `SECONDPASSWORD`: Second operator password `DISABLED`: Operator blocked `SERVERRIGHTS`: Server authorization,
`<value>`	Value of 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 Authorization Put a plus sign before the server authorizations to assign it and a minus sign to revoke it. If you specify more than one server authorization, you should separate them with commas.

Result

OK

In the event of errors, see Reply Format.

Example

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

change the password for the DBM operator ELENA to the value SATURDAY, assign the server authorization to start database instances and revoke the server authorization to stop database instances:

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

OK

More Information

Glossary, Server Permission

Database Manager CLI Tutorial, Creating DBM Operators

Database Administration, DBM Operators, Database Users