An access control list (ACL) is created by default on the root
file of each Oracle Rdb database. To be able to use a particular
Oracle RMU command for the database, you must be granted
the appropriate Oracle RMU privilege for that command in the
database's root file ACL. For some Oracle RMU commands, you must
have one or more OpenVMS privileges as well as the appropriate
Oracle RMU privilege to be able to use the command.
Note that the root file ACL created by default on each Oracle Rdb
database controls only your Oracle RMU access to the database (by
specifying privileges that will allow a user or group of users
access to specific Oracle RMU commands). Root file ACLs do not
control your access to the database with SQL (structured query
language) statements. See Show Privilege for information on how
to display your Oracle RMU access to the database.
Your access to a database with SQL statements is governed by
the privileges granted to you in the database ACL (the ACL that
is displayed when you use the SQL SHOW PROTECTION ON DATABASE
command).
Privileges Required for Oracle RMU Commands shows the Oracle RMU
privileges you must have to use each Oracle RMU command. When
more than one Oracle RMU privilege appears in the Required Oracle
RMU Privileges column, if you have any of the listed Oracle RMU
privileges, you will pass the Oracle RMU privilege check for the
specified Oracle RMU command.
If the Oracle RMU command requires a user to have one or more
OpenVMS privileges in addition to the appropriate Oracle RMU
privileges, the OpenVMS privileges are shown in the Required
OpenVMS Privileges column of Privileges Required for Oracle RMU
Commands. When more than one OpenVMS privilege is listed in the
Required OpenVMS Privileges column, you must have all of the
listed OpenVMS privileges to pass the OpenVMS privilege check for
the Oracle RMU command.
The OpenVMS Override Privileges column of Privileges Required
for Oracle RMU Commands shows one or more OpenVMS privileges
that allow a user without the appropriate required Oracle RMU and
OpenVMS privileges for an Oracle RMU command to use the command
anyway. When more than one OpenVMS privilege is listed in the
OpenVMS Override Privileges column, you can use the specified
Oracle RMU command if you have any of the listed privileges.
Table 1 Privileges Required for Oracle RMU Commands
Required
Oracle Required
Oracle RMU RMU OpenVMS OpenVMS Override
Command Privileges Privileges Privileges
Alter RMU$ALTER SYSPRV, BYPASS
Analyze Areas RMU$ANALYZE SYSPRV, BYPASS
Analyze RMU$ANALYZE SYSPRV, BYPASS
Cardinality
Analyze Indexes RMU$ANALYZE SYSPRV, BYPASS
Analyze RMU$ANALYZE SYSPRV, BYPASS
Placement
Backup RMU$BACKUP SYSPRV, BYPASS
Backup After_ RMU$BACKUP SYSPRV, BYPASS
Journal
Backup Plan RMU$BACKUP SYSPRV, BYPASS
Checkpoint RMU$BACKUP, WORLD
RMU$OPEN
Close RMU$OPEN WORLD
Collect RMU$ANALYZE SYSPRV, BYPASS
Optimizer_
Statistics
Convert RMU$CONVERT, SYSPRV, BYPASS
RMU$RESTORE
Copy_Database RMU$COPY SYSPRV, BYPASS
Delete RMU$ANALYZE SYSPRV, BYPASS
Optimizer_
Statistics
Dump After_ RMU$DUMP SYSPRV, BYPASS
Journal
Dump Areas RMU$DUMP SYSPRV, BYPASS
Dump Backup_File RMU$DUMP, READ BYPASS
RMU$BACKUP,
RMU$RESTORE
Dump Export READ BYPASS
Dump Header RMU$DUMP, SYSPRV, BYPASS
RMU$BACKUP,
RMU$OPEN
Dump Lareas RMU$DUMP SYSPRV, BYPASS
Dump Recovery_ READ BYPASS
Journal
Dump Row Cache RMU$DUMP SYSPRV, BYPASS
Dump Snapshots RMU$DUMP SYSPRV, BYPASS
Dump Users RMU$DUMP, WORLD
RMU$BACKUP,
RMU$OPEN
Extract RMU$UNLOAD SYSPRV, BYPASS
Insert Optimizer RMU$ANALYZE SYSPRV,
Statistics BYPASS
Load RMU$LOAD SYSPRV, BYPASS
Load Audit RMU$SECURITY SECURITY, BYPASS
Load Plan RMU$LOAD SYSPRV, BYPASS
Monitor Reopen_ WORLD, SETPRV
Log CMKRNL,
DETACH,
PSWAPM,
ALTPRI,
SYSGBL,
SYSNAM,
SYSPRV,
BYPASS
Monitor Start WORLD, SETPRV
CMKRNL,
DETACH,
PSWAPM,
ALTPRI,
PRMMBX,
SYSGBL,
SYSNAM,
SYSPRV,
BYPASS
Monitor Stop WORLD, SETPRV
CMKRNL,
DETACH,
PSWAPM,
ALTPRI,
PRMMBX,
SYSGBL,
SYSNAM,
SYSPRV,
BYPASS
Move_Area RMU$MOVE SYSPRV, BYPASS
Open RMU$OPEN WORLD
Optimize After_ RMU$BACKUP, SYSPRV, BYPASS
Journal RMU$RESTORE
Reclaim RMU$ALTER SYSPRV, BYPASS
Recover RMU$RESTORE SYSPRV, BYPASS
Recover Resolve RMU$RESTORE SYSPRV, BYPASS
Repair RMU$ALTER SYSPRV, BYPASS
Resolve RMU$RESTORE SYSPRV, BYPASS
Restore RMU$RESTORE SYSPRV, BYPASS
Restore Only_ RMU$RESTORE SYSPRV, BYPASS
Root
Server After_ RMU$OPEN WORLD
Journal Reopen_
Output
Server After_ RMU$OPEN WORLD
Journal Start
Server After_ RMU$OPEN WORLD
Journal Stop
Server Backup_ RMU$OPEN WORLD
Journal Resume
Server Backup_ RMU$OPEN WORLD
Journal Suspend
Server Record_ RMU$OPEN WORLD
Cache
Set After_ RMU$ALTER, SYSPRV, BYPASS
Journal RMU$BACKUP,
RMU$RESTORE
Set AIP RMU$DUMP SYSPRV, BYPASS
Set Audit RMU$SECURITY SECURITY, BYPASS
Set Buffer RMU$ALTER SYSPRV, BYPASS
Object
Set Corrupt_ RMU$ALTER, SYSPRV, BYPASS
Pages RMU$BACKUP,
RMU$RESTORE
Set Galaxy RMU$ALTER SYSPRV, BYPASS
Set Global RMU$ALTER SYSPRV, BYPASS
Buffers
Set Logminer RMU$ALTER, SYSPRV, BYPASS
RMU$BACKUP,
RMU$RESTORE
Set Privilege RMU$SECURITY SECURITY, BYPASS
Set Row_Cache RMU$ALTER SYSPRV, BYPASS
Set Shared RMU$ALTER SYSPRV, BYPASS
Memory
Show After_ RMU$BACKUP, SYSPRV, BYPASS
Journal RMU$RESTORE,
RMU$VERIFY
Show AIP RMU$DUMP SYSPRV, BYPASS
Show Audit RMU$SECURITY SECURITY, BYPASS
Show Corrupt_ RMU$BACKUP, SYSPRV, BYPASS
Pages RMU$RESTORE,
RMU$VERIFY
Show Locks WORLD
Show Optimizer_ RMU$ANALYZE, SYSPRV, BYPASS
Statistics RMU$SHOW
Show Privilege RMU$SECURITY SECURITY, BYPASS
Show Statistics RMU$SHOW SYSPRV, BYPASS, WORLD
Show System WORLD
Show Users RMU$SHOW, WORLD
RMU$BACKUP,
RMU$OPEN
Show Version
Unload RMU$UNLOAD SYSPRV, BYPASS
Unload After_ RMU$DUMP SYSPRV, BYPASS
Journal
Verify RMU$VERIFY SYSPRV, BYPASS