Background documentationuser_get Locate this document in the navigation structure

 

With this command you can display the DBM operator properties and server permissions for the specified DBM operator, or the database system administrator (The database system administrator is the DBM operator with the most comprehensive rights.).

Prerequisites

You have the DBInfoRead server permission.

Structure

user_get <dbm_operator>

Options

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]

Values for the Reply Fields

Value

Description

SERVERRIGHTS

All server permissions of the specified user 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 | DBM

DBA: Database system administrator

DBM: DBM operator

In the event of errors, see Reply Format.

Example

Call Database Manager CLI, log on as the operator OLEG with the password MONDAY, connect to the DEMODB database and display the server permissions and properties of the DBM operator 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