user_getrights

Use

You display the list of server authorizations of the specified DBM operator.

See also:

Server Authorizations

Concepts of the Database System, Database Manager Operator (DBM Operator)

Prerequisites

You have the DBInfoRead server authorization.

Syntax

user_getrights <dbm_operator> SERVERRIGHTS

<dbm_operator>

Name of the DBM operator

Reply

OK

UserMgm                 <flag>  User management

InstallMgm              <flag>  Install management

SystemCmd               <flag>  System commands

FileFull                <flag>  File full access

FileRead                <flag>  File read access

DBFileRead              <flag>  Database file read access

AccessUtility           <flag>  Utility session access

BackupRestore           <flag>  Backup restore actions

BackupSave              <flag>  Backup save actions

ParamFull               <flag>  Parameter full access

ParamCheckWrite         <flag>  Parameter check-write access

ParamRead               <flag>  Parameter read access

AccessSQL               <flag>  SQL session access

ExecLoad                <flag>  Can execute load

LoadSysTab              <flag>  Can load system tables

DBStop                  <flag>  Can stop database

DBStart                 <flag>  Can start database

DBInfoRead              <flag>  Info functions access

Values for the Reply Fields

Field

Description

<flag>

Indicates whether the DBM user has the relevant server authorization. Possible values are:
+: user has server authorization

-: user does not have server authorization.

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 of the registered DBM operator with the name ELENA

>dbmcli -u OLEG,MONDAY -d DEMODB user_getrights ELENA SERVERRIGHTS

OK

DBInfoRead              +       Request status data

SystemCmd               +       Execute operating system commands

ExecLoad                +       Execute the LOAD program

UserMgm                 +       User management

DBFileRead              +       Database file access (read only)

Backup                  +       Saving backups

InstallMgm              +       Installation management

LoadSysTab              +       Load the system tables

ParamCheckWrite         +       Parameter access (checked write)

ParamFull               +       Parameter access (read and write)

ParamRead               +       Parameter access (read only)

DBStart                 +       Start database instance

DBStop                  +       Stop database instance

Recovery                +       Restoring backups

AccessSQL               +       Access to SQL session

AccessUtility           +       Access to utility session

SharedMemoryMgm         +       Shared memory management

SchedulerMgm            +       Scheduler management

Scheduling              +       Scheduler use

EvtDispMgm              +       Event Dispatcher management

EvtDisp                 +       Event Dispatcher use