VMS Help  —  RMU72  Show  Privilege
    Allows you to display the root file access control list (ACL) for
    a database.

1  –  Format

  (B)0RMU/Show Privilege root-file-spec

   Command Qualifiers        x  Defaults
                             x
   [No]Expand_All            x  /Noexpand_All
   [No]Header                x  /Header

2  –  Parameters

2.1  –  root-file-spec

    The root file specification for the database whose root file
    ACL you are displaying. By default, a file extension of .rdb is
    assumed.

3  –  Command Qualifiers

3.1  –  Expand All

    Noexpand_All

    Specifies that if a user's access mask was defined with the
    RMU$ALL keyword on the RMU Set Privilege command, each of the
    RMU privileges represented by the RMU$ALL keyword is displayed.

    The Noexpand_All qualifier specifies that if a user's access mask
    was defined with the RMU$ALL keyword on the RMU Set Privilege
    command, only the keyword is displayed; the RMU privileges
    represented by the keyword are not displayed.

    The Noexpand_All qualifier is the default.

3.2  –  Header

    Noheader

    Specifies that header information is to be displayed. The
    Noheader qualifier suppresses output of header information.

    The Header qualifier is the default.

4  –  Usage Notes

    o  To use the RMU Show Privilege command for a database, you must
       have the RMU$SECURITY privilege in the root file ACL for the
       database or the OpenVMS SECURITY or BYPASS privilege.

    o  Although you can use the DCL SHOW ACL command to display the
       root file ACL for a database, the DCL SHOW ACL command does
       not display the names of the Oracle RMU privileges granted to
       users.

5  –  Examples

    Example 1

    In the following example, the RMU Show Privilege command displays
    the root file ACL for the mf_personnel database:

    $ RMU/SHOW PRIVILEGE MF_PERSONNEL.RDB
    Object type: file,  Object name: SQL_USER:[USER1]MF_PERSONNEL.RDB;1,
     on 12-FEB-1996 10:48:23.04

     (IDENTIFIER=[SQL,USER1],ACCESS=READ+WRITE+CONTROL+RMU$ALTER+
     RMU$ANALYZE+RMU$BACKUP+RMU$CONVERT+RMU$COPY+RMU$DUMP+RMU$LOAD+
     RMU$MOVE+RMU$OPEN+RMU$RESTORE+RMU$SECURITY+RMU$SHOW+RMU$UNLOAD+
     RMU$VERIFY)
     (IDENTIFIER=[SQL,USER2],ACCESS=READ+WRITE+RMU$ALTER+RMU$ANALYZE+
     RMU$BACKUP+RMU$CONVERT+RMU$COPY+RMU$DUMP+RMU$LOAD+RMU$MOVE+RMU$OPEN+
     RMU$RESTORE+RMU$SHOW+RMU$UNLOAD+RMU$VERIFY)
     (IDENTIFIER=[SQL,USER3],ACCESS=READ+WRITE+CONTROL+RMU$SECURITY)

    Example 2

    The following examples demonstrate the difference in output when
    you use the Header and Noheader qualifiers:

    $ RMU/SHOW PRIV MF_PERSONNEL.RDB/HEADER
    Object type: file,  Object name: RDBVMS_USER:[DB]MF_PERSONNEL.RDB;1,
     on 17-SEP-1998 13:47:20.21
              (IDENTIFIER=[RDB,STONE],ACCESS=RMU$ALL)

    $ RMU/SHOW PRIVILEGE MF_PERSONNEL.RDB/NOHEADER
              (IDENTIFIER=[RDB,STONE],ACCESS=RMU$ALL)

    Example 3

    The following examples demonstrate the difference in output when
    you use the Expand and Noexpand qualifiers:

    $ RMU/SET PRIVILEGE MF_PERSONNEL.RDB /ACL=(I=STONE,A=RMU$ALL)

    $ RMU/SHOW PRIVILEGE MF_PERSONNEL.RDB /NOEXPAND/NOHEADER
    (IDENTIFIER=[RDB,STONE],ACCESS=READ+WRITE+CONTROL+RMU$ALL)

    $ RMU/SHOW PRIVILEGE MF_PERSONNEL.RDB /EXPAND/NOHEADER
    (IDENTIFIER=[RDB,STONE],ACCESS=READ+WRITE+CONTROL+RMU$ALTER+
          RMU$ANALYZE+RMU$BACKUP+RMU$CONVERT+RMU$COPY+RMU$DUMP+RMU$LOAD+
          RMU$MOVE+RMU$OPEN+RMU$RESTORE+RMU$SECURITY+RMU$SHOW+RMU$UNLOAD+
          RMU$VERIFY)
Close Help