Background documentationuser_getrights Locate this document in the navigation structure

 

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

Prerequisites

You have the DBInfoRead server authorization.

Structure

user_getrights <dbm_operator> SERVERRIGHTS

Options

Option

Description

<dbm_operator>

Name of the DBM operator

Result

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

Values for the Reply Fields

Value

Description

<flag>

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

+: Operator has this server authorization.

-: Operator does not have this 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 and display the server authorizations of the DBM operator called ELENA, who was created for this database instance:

>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

More Information

Glossary, Server Permission

Database Administration, DBM Operators