My Oracle Support Banner

RDBPROD: RMU/SET AUDIT Command, Syntax, Examples, and General Information. (Doc ID 413414.1)

Last updated on APRIL 16, 2024

Applies to:

Oracle Rdb Server on OpenVMS - Version 6.1 and later
HP OpenVMS Alpha
HP OpenVMS Itanium
HP OpenVMS VAX

Goal

The ability to audit access to an Rdb database is provided through the use of the RMU Audit utility.  There are four levels or classes that can be audited through the use of this utility.  Only the discretionary access class (DACCESS) is discussed here.  Discretionary Access is used to track who issues SQL and RMU commands and is typically the most popular level to audit within a database.  The discussion that follows provides examples on how to audit events for an Rdb table and a specific user, as well as options for analyzing results.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
 1. Display the audit status before doing anything at all with RMU/SET AUDIT:
 2. Enabling and disabling audit for a specific user:
 3. Enable and start audit for a specific database object:
 4. To enable the daccess class for the database:
 5. Viewing and analyzing audit records:
 
6. Disabling audit for a specific database object:
 7. Disabling RMU audits for the database:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.