DTRHELP.HLB  —  Commands Statements Clauses, SHOWP Command
       Displays the access control list (ACL) of an object or directory
       in the
       Oracle CDD/Repository data dictionary.

       Format

         SHOWP  path-name

1  –  Argument

    path-name

       Is the given name, full dictionary path name, or relative path
       name of the dictionary object or directory whose access control
       list you want to display.

2  –  Examples

       The following example displays the access control list for the
       DMU YACHTS domain:

       DTR>  SHOWP YACHTS
         1:    [*,*], Username: "JONES"
               Grant - CDEHMRSUW, Deny - none, Banish - none

       DTR>

       The following example uses a password to gain C (CONTROL) access
       to the DMU record YACHT and then display its access control list:

       DTR>  SHOWP YACHT (*)
       Enter password for YACHT:   !You enter CEP, which is not echoed.
       DTR>  SHOWP YACHT
         1:    [*,*], Password: "P"
               Grant - P, Deny - CDESUX, Banish - none
         2:    [*,*], Password: "DP"
               Grant - DP, Deny - CESUX, Banish - none
         3:    [*,*], Password: "EP"
               Grant - EP, Deny - CDSUX, Banish - none
         4:    [*,*], Password: "PS"
               Grant - PS, Deny - CDEUX, Banish - none
         5:    [*,*], Password: "PU"
               Grant - PU, Deny - CDESX, Banish - none
         6:    [*,*], Password: "PX"
               Grant - PX, Deny - CDESU, Banish - none
         7:    [*,*], Password: "CEP"
               Grant - CEP, Deny - DSUX, Banish - none
         8:    [*,*], Password: "CDP"
               Grant - CDP, Deny - ESUX, Banish - none

       DTR>

       The following example displays the ACL of the CDO format
       dictionary SYS$COMMON:[CDDPLUS.PERSONNEL]:

    DTR> SHOWP SYS$COMMON:[CDDPLUS.PERSONNEL]
     1: [*,*], Username: "CASADAY"
        GRANT - RWMESUDC, DENY - none
        ACCESS=READ+WRITE+MODIFY+EXTEND+SHOW+DEFINE+CHANGE+DELETE+CONTROL
     2: [*,*]
        GRANT - S, DENY - RWMEUDC
        ACCESS=SHOW

    DTR>
Close Help