Audit records are inserted into the PAUDIT table. One record is inserted into the audit table for each row changed in the database.
PAUDIT 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 Professional user name if the change was made in P6 Professional 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 |
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 |
* Values will differ for depending on your database. |
Note: Grant select privileges to the administrative user on V_$SESSION to ensure correct values for several auditing table values.