HP 3000 Manuals

DISPLAY USERS [ IMAGE/SQL Administration Guide ] MPE/iX 5.0 Documentation


IMAGE/SQL Administration Guide

DISPLAY USERS 

Displays current user information for a specific TurboIMAGE/XL database.

Syntax 
[REV BEG]

DI[SPLAY] USER[S] [FOR TurboDB] [USER={User@Account}[,..  .]]
                                      {User.Account}
[REV END]

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.  For the
named TurboIMAGE/XL database, the DBOPEN mode and the TurboIMAGE/XL
database passwords are displayed for all IMAGE/SQL users or for those
users specified by the User@Account parameter.

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.
________________________________________________________________
|                                                              |
|     >>DISPLAY USER USER=NANCY@ATC                            |
|                                                              |
|     TurboIMAGE/XL DB : SALES.SERED.ATC                       |
|     DBEnvironment    : PARTSDBE.SERED.ATC                    |
|                                                              |
|     USER LOGON         DBOPEN MODE  USER PASSWORD  USER CLASS|
|     ----------         -----------  -----------    ----------|
|                                                              |
|     NANCY@ATC          1            ;              64        |
|                                                              |
|     >>                                                       |
________________________________________________________________

            



MPE/iX 5.0 Documentation