You can change the passwords for all the Database Manager operators (DBM operators) and the database system administrator (SYSDBA user) in the following operating states of the database instance:
User |
Operating State |
First DBM operator All other DBM operators |
OFFLINE Password can be changed in every operating state |
Database system administrator |
ONLINE |
The new values are assigned with <property>=<value>. You can specify all the authorizations of a DBM operator for <property>.
For the SERVERRIGHTS property, you can specify multiple values, separated by commas. To assign an authorization, enter a plus sign in front of it; to revoke an authorization, enter a minus sign in front of it.
You have the server authorization UserMgm.
If you want to change the password for the first DBM operator, the operational state of the database instance must be OFFLINE. If you want to change the password for a normal DBM operator, the operational state of the database instance is not important.
user_put <user_name> <property>=<value>[, <property>=<value>, ...]
<property> ::= PASSWORD | COMMENT | DISABLED | SECONDPASSWORD | SERVERRIGHTS
Note the Conventions for User Names and Passwords. The database system automatically converts passwords for DBM operators into upper-case letters.
The system displays an OK message.
In the event of errors, see Reply Format.
Logging on to the Database Manager CLI as user DBM with password DBM, connecting to the HOTELDB database instance, assigning the server authorization for starting database instances and revoking the server authorization for stopping database instances for the user with the user name MONA
dbmcli –u DBM,DBM –d HOTELDB user_put MONA SERVERRIGHTS=+StartDB, -StopDB
OK