Syntax for Security Display Statements › Notes on DISPLAY/PUNCH Statement Syntax › Usage

Usage

Wildcards

If a wildcarded name was used in the resource definition or the grant of privilege on the resource, the DISPLAY statement must specify the wildcarded name.

Correspondence to DDDL Syntax

The preceding common parameters for DISPLAY statements have the same function that they have in DDDL syntax. In general, the conventions of security DISPLAY statement syntax will be familiar to the DDDL user.

Note: For more information about DDDL, see the CA IDMS IDD DDDL Reference Guide.

Specifying AS SYNTAX

This example shows the output of a security DISPLAY statement that specifies AS SYNTAX:

DISPLAY USER DICK WITH ALL AS SYNTAX;
     CREATE USER DICK
*+       USER IS ACTIVE
         DESCRIPTION 'CHIEF ANALYST'
         NAME 'RICHARD A. ANALYST'
*+       PASSWORD ASSIGNED
         PROFILE PAYROLL
*+       CREATED 1991-07-18-12.51.17.187373 BY KKS
*+       LAST UPDATED 1991-07-18-12.51.23.000517 BY KKS
*+       WITHIN GROUP DEVTEAM
*+       HOLDS DEFINE PRIVILEGES ON USER TOM
*+       HOLDS DEFINE PRIVILEGES ON SYSTEM SYSTEM71
*+       HOLDS SIGNON PRIVILEGES ON SYSTEM SYSTEM71
*+       HOLDS DBADMIN PRIVILEGES ON DB FRED
*+       HOLDS DBAWRITE PRIVILEGES ON AREA THESEGMENT.CORPTSP
*+       HOLDS USE PRIVILEGES ON DMCL THEDMCL
*+       HOLDS USE PRIVILEGES ON DBTABLE THEDBTABLE
*+       HOLDS USE PRIVILEGES ON DB THEDB
*+       HOLDS EXECUTE PRIVILEGES ON CATEGORY CATE3
*+       HOLDS EXECUTE PRIVILEGES ON ACTIVITY DCMT.N002
*+       HOLDS REFERENCES PRIVILEGES ON ACCESS MODULE THESCHEMA.THEAM
*+       HOLDS EXECUTE PRIVILEGES ON ACCESS MODULE THESCHEMA.THEAM
*+       HOLDS ALL PRIVILEGES ON TABLE THESCHEMA.THE*
*+       HOLDS DISPLAY PRIVILEGES ON ACCESS MODULE THESCHEMA.*
*+       HOLDS DISPLAY PRIVILEGES ON ACCESS MODULE THESCHEMA.FRED*
*+       HOLDS REFERENCES PRIVILEGES ON TABLE THESCHEMA.THETABLE
*+       HOLDS SELECT, INSERT, UPDATE PRIVILEGES ON TABLE THESCHEMA.THETABLE
*+       HOLDS DISPLAY PRIVILEGES ON TABLE THESCHEMA.*
         ;

Specifying AS COMMENTS

This example shows the output of a security DISPLAY statement that specifies AS COMMENTS:

DISPLAY USER DICK WITH ALL AS COMMENTS;
*+   CREATE USER DICK
*+       USER IS ACTIVE
*+       DESCRIPTION 'CHIEF ANALYST'
*+       NAME 'RICHARD A. ANALYST'
*+       PASSWORD ASSIGNED
*+       PROFILE PAYROLL
*+       CREATED 1991-07-18-12.51.17.187373 BY KKS
*+       LAST UPDATED 1991-07-18-12.51.23.000517 BY KKS
*+       WITHIN GROUP DEVTEAM
*+       HOLDS DEFINE PRIVILEGES ON USER TOM
*+       HOLDS DEFINE PRIVILEGES ON SYSTEM SYSTEM71
*+       HOLDS SIGNON PRIVILEGES ON SYSTEM SYSTEM71
*+       HOLDS DBADMIN PRIVILEGES ON DB FRED
*+       HOLDS DBAWRITE PRIVILEGES ON AREA THESEGMENT.CORPTSP
*+       HOLDS USE PRIVILEGES ON DMCL THEDMCL
*+       HOLDS USE PRIVILEGES ON DBTABLE THEDBTABLE
*+       HOLDS USE PRIVILEGES ON DB THEDB
*+       HOLDS EXECUTE PRIVILEGES ON CATEGORY CATE3
*+       HOLDS EXECUTE PRIVILEGES ON ACTIVITY DCMT.N002
*+       HOLDS REFERENCES PRIVILEGES ON ACCESS MODULE THESCHEMA.THEAM
*+       HOLDS EXECUTE PRIVILEGES ON ACCESS MODULE THESCHEMA.THEAM
*+       HOLDS ALL PRIVILEGES ON TABLE THESCHEMA.THE*
*+       HOLDS DISPLAY PRIVILEGES ON ACCESS MODULE THESCHEMA.*
*+       HOLDS DISPLAY PRIVILEGES ON ACCESS MODULE THESCHEMA.FRED*
*+       HOLDS REFERENCES PRIVILEGES ON TABLE THESCHEMA.THETABLE
*+       HOLDS SELECT, INSERT, UPDATE PRIVILEGES ON TABLE THESCHEMA.THETABLE
*+       HOLDS DISPLAY PRIVILEGES ON TABLE THESCHEMA.*