user_get 

Use

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.

See also:

Concepts of the Database System, Users, Authentication and Authorizations

Prerequisites

You have the DBInfoRead server authorization.

Syntax

user_get <dbm_operator>

<dbm_operator>

Name of the DBM operator or database system administrator

Reply

OK

SERVERRIGHTS=<right_list>

SECONDPASSWORD=[YES|NO]

DISABLED=[YES|NO]

COMMENT=<comment>

USERTYPE=[DBM|DBA]

Values for the Reply Fields

Field	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: YES | NO
DISABLED	Indicates whether the DBM operator is blocked. Possible values: YES | NO
COMMENT	Description
USERTYPE	Operator 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, display the rights and operator properties of the DBM operator with the name 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