user_get 
You display the DBM operator properties and server authorizations for the specified DBM operator or database system administrator.
The Database Manager outputs, among other things, a list of the server authorizations assigned to the operator.
Prerequisites
You have the DBInfoRead server authorization.
Structure
user_get <dbm_operator>
Option | Description |
|---|---|
<dbm_operator> | Name of the DBM operator or database system administrator |
Result
OK
SERVERRIGHTS=<right_list>
SECONDPASSWORD=[YES|NO]
DISABLED=[YES|NO]
COMMENT=<comment>
USERTYPE=[DBM|DBA]
Value | Description |
|---|---|
SERVERRIGHTS | All server authorizations of the DBM operator separated by commas |
SECONDPASSWORD | Indicates whether a second password has been activated for the DBM operator. Possible values are: YES | NO |
DISABLED | Indicates whether the DBM operator is locked. Possible values are: YES | NO |
COMMENT | Description |
USERTYPE | User type Possible values are: DBA: Database system administrator DBM: DBM operator |
In the event of errors, see Reply Format.
Example
Call the Database Manager CLI, log on as operator OLEG with password MONDAY, connect to the DEMODB database instance and display the server authorizations and DBM operator properties of the DBM operator called ELENA:
>dbmcli -u OLEG,MONDAY -d DEMODB user_get ELENA
OK
SERVERRIGHTS=DBInfoRead,ExecLoad,SystemCmd,UserMgm,DBFileRead,Backup,...
SECONDPASSWORD=NO
DISABLED=NO
COMMENT=
USERTYPE=DBM
More Information
Database Administration, Managing Users