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>