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)