DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: audit

  1. #1
    Join Date
    Jan 2001
    Posts
    13

    Exclamation

    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

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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
  •  


Click Here to Expand Forum to Full Width