DISPLAY USERS [ IMAGE/SQL Administration Guide ] MPE/iX 5.5 Documentation
IMAGE/SQL Administration Guide
DISPLAY USERS
Displays current user information for a specific TurboIMAGE/XL database.
Syntax
DI[SPLAY] USER[S] [FOR TurboDB] [USER={User@Account}[,.. .]]
{User.Account}
Parameters
TurboDB is the name of the TurboIMAGE/XL database whose user
information you want to display. If this parameter is
omitted, the name of the database defined in the most
recent SET TURBODB command is used.
User@Account is the name used to identify a particular user in the
DBEnvironment. This name, referred to as the DBEUserID, is
made up of the user's MPE/iX user and account names,
connected with the period or @ symbol. If this parameter
is omitted, information about all currently defined users
is displayed.
Prerequisites
* SET SQLDBE issued.
* SET TURBODB issued or TurboIMAGE/XL database specified as part of
the command.
* DBC status.
* Database attached.
Description
Use the DISPLAY USERS command to display information about users of the
TurboIMAGE/XL database named in the last SET TURBODB command.[REV BEG]
For the named TurboIMAGE/XL database, the DBOPEN mode, the passwords, and
classes are displayed for all IMAGE/SQL users or for those users
specified by the User@Account parameter when viewed by DBC.
A user who is not the DBC, can view user information without displaying
passwords.[REV END]
To change the DBOPEN mode or the user class for a specified user, refer
to the UPDATE USER command. To add or delete users, refer to the ADD
USER and DELETE USER commands.
Example
In the following example, information is displayed about user
NANCY@ATC.[REV BEG]
________________________________________________________________
| |
| >>DISPLAY USER USER=NANCY@ATC |
| |
| TurboIMAGE/XL DB : SALES.SERED.ATC |
| DBEnvironment : PARTSDBE.SERED.ATC |
| Owner Name : SALES |
| |
| USER LOGON DBOPEN MODE USER PASSWORD USER CLASS|
| ---------- ----------- ----------- ----------|
| |
| NANCY.ATC 1 ; 64 |
| |
| >> |
________________________________________________________________
[REV END]
MPE/iX 5.5 Documentation