Allows you to display the root file access control list (ACL) for a database.
1 – Format
(B)0[mRMU/Show Privilege root-file-spec [4mCommand[m [4mQualifiers[m x [4mDefaults[m 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)