Audit (FGA) of "execute procedure" action
675346Sep 7 2009 — edited Sep 8 2009Hi all!
I am setting up fine grained auditing in our test database.
I have done this for all tables, no problem.
But I cannot figure out how to do this for procedures. I want to audit all procedure and packages in our database to get information which ones are executed by our appliction.
Anyone knows how to set up a procdure/package audit?
--------------------------
This is the syntax for setting up table audit.
execute DBMS_FGA.ADD_POLICY(
object_schema => 'TRA' ,
object_name => 'PERS' ,
policy_name => 'PERS' ,
statement_types => 'SELECT, INSERT,UPDATE,DELETE');