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

Thread: Audit DBA role users on 8.0.3

  1. #1
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Question Audit DBA role users on 8.0.3

    I want to audit users SYS, SYSTEM and other database users who have DBA role. Audit event is logon / logoff to / from the database. Please note that this is for Oracle 8.0.3, so I cannot use 8i feature of trigger using 'AFTER LOGON ON DATABASE'.

    Thanks.

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    I think I have found it! I need to try it out and see if it works as intended. However, this method only gives username, logon & logoff time. I need osuser & machine atleast.

    audit_trail = db

    audit session by SYS, SYSTEM, JACK;

    (JACK has the dba role).

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