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