user_put

Use

You can change the DBM operator properties and server authorizations of DBM operators and of the database system administrator.

See Conventions for User Names and Passwords.
The database system automatically converts passwords for DBM operators into upper-case letters.

See also:

Server Authorizations

Database Administration Tutorial, Creating DBM Operators

Concepts of the Database System, Database Manager Operator (DBM Operator), Database User

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.

Syntax

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 Database Manager operator or database system administrator whose properties are to be changed.

<property>

Property of operator. The possible values are:

PASSWORD: operator password

COMMENT: description

SECONDPASSWORD: second operator password

DISABLED: operator is blocked

SERVERRIGHTS: server authorization. 

<value>

Value of the property allocated.

Possible values for DBM operator properties PASSWORD, COMMENT and SECONDPASSWORD. Any values can be chosen here.

Possible values for DISABLED: YES | NO
YES: operator is blocked
NO: operator is not blocked

Possible values for SERVERRIGHTS: see Server Authorizations
Place a plus sign in front of the server authorization to assign it and a minus sign to revoke it. If you specify more than one server authorization, you should separate them with commas.

Reply

OK

In the event of errors, see Reply Format.

Example

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

change the operator 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