Audit records are inserted into the PRMAUDIT table. One record is inserted into the audit table for each row changed in the database.
PRMAUDIT Table | ||
Column | Type | Description |
audit_date | Date | Date and time of change |
table_name | String(30) | Table Name |
pk1, pk2, pk3, pk4 | String(255) | Primary key values for audited record |
oper | String(1) | I=Insert, U=Update, D=Delete |
prm_user_name | String(32) | P6 EPPM user name if the change was made in P6 EPPM applications |
audit_info | String(4000) | Column changes up to 4000 characters (Level 2 and 3 only) |
audit_info_extended | BLOB | Blob changes and overflow from audit_info (Level 2 and 3 only) |
logical_delete_flag | String(1) | Flag for deletes that are logical (marked) rather than a physical delete |
rdbms_user_name* | String(255) | Database user name (usually privuser) |
os_user_name* | String(255) | Operating system user name of connected session
Note: When auditing is enabled against a SQL Server database, |
program* | String(255) | Name of program connecting to the database |
host_name* | String(255) | Computer name of connected session |
app_name* | String(25) | Name of application connected to the database |
netaddress* | String(24) | IP or MAC address of connected session |
Note: Grant select privileges to the administrative user on V_$SESSION to ensure correct values for several auditing table values.
Related Topics |
Legal Notices
Copyright © 1999, 2016,
Oracle and/or its affiliates. All rights reserved.
Last Published Thursday, February 04, 2016