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. 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.

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

   Owner Name       : SALES



   USER LOGON         DBOPEN MODE  USER PASSWORD  USER CLASS

   ----------         -----------  -----------    ----------



   NANCY.ATC          1            ;              64



   >>

DISPLAY USERS

Technical documentation

» Table of Contents

» Glossary

» Index

Syntax

Parameters

Prerequisites

Description

Example