quick quesiton on audit.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: quick quesiton on audit.

  1. #1
    Join Date
    Feb 2001
    Posts
    51
    hello,

    is there a way I can check what auditing features I have enable on my box?

    and what is the command to disabled the auditing, if there is any.

    thanks

  2. #2
    [url]http://oradoc.photo.net/ora817/DOC/server.817/a76956/audit.htm#1108[/url]
    :)
    select * from <next_views>
    DBA_AUDIT_TRAIL, DBA_AUDIT_OBJECT, DBA_AUDIT_SESSION, DBA_AUDIT_STATEMENT, DBA_AUDIT_EXISTS

    NOAUDIT session;
    NOAUDIT session BY scott, lori;
    NOAUDIT DELETE ANY TABLE;
    NOAUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE,
    EXECUTE PROCEDURE;
    Ramon Caballero, DBA, rcaballe@yahoo.com

  3. #3
    Join Date
    Feb 2001
    Posts
    51
    thanks!

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