-
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.
Valentin
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|