audit

[valentin]

Hi,

I´m auditing some tables (select, insert, update, delete). When I perform this query
select obj_name, action_name from dba_audit_object;

The column action_name only returns "SESSION REC".
Anybody says me what´s SESSION REC?

Best regards,

Valentin.

[sreddy]

1* select distinct(ACTION_NAME) from dba_audit_object
SQL> /

ACTION_NAME
---------------------------
ALTER ROLE
ALTER USER
CREATE PUBLIC SYNONYM
CREATE ROLE
CREATE TABLE
CREATE TRIGGER
CREATE USER
DELETE
DISABLE TRIGGER
DROP PUBLIC SYNONYM
DROP TABLE
DROP USER
ENABLE TRIGGER
EXECUTE PROCEDURE
SELECT
SESSION REC
SET ROLE

17 rows selected.

I guess SESSION REC is just recording the session. ACTION NAME represents what kinda action you are auditing.

ACTION_NAME: Name of the action type corresponding to the numeric code for ACTION column in DBA_AUDIT_TRAIL.