Oracle Database Auditing for Procedures
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Oracle Database Auditing for Procedures

  1. #1
    Join Date
    Jan 2002
    Posts
    65
    Hi,

    In order to activate auditing for a table named Tab_YYY owned by say Own_XXX I can use the following query.

    AUDIT SELECT, INSERT, UPDATE, DELETE ON Own_XXX .Tab_YYY BY ACCESS WHENEVER SUCCESSFUL;

    But suppose I have a Stored PL/SQL Procedure, then how do I activate auditing for this?

    I tried the above query but the above query seems to be only for Table and Packages

    Is there no way by means of which auditing option can be activated for functions and procedures?

    Sabitabrata

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    You need:

    AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE, EXECUTE PROCEDURE BY ACCESS WHENEVER SUCCESSFUL;

    Or:

    AUDIT EXECUTE PROCEDURE ON schema.procedure BY ACCESS WHENEVER SUCCESSFUL;

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

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