Home » RDBMS Server » Security » audit usage of procedure in a package (ORACLE 11)
audit usage of procedure in a package [message #408922] Thu, 18 June 2009 05:45 Go to next message
aline
Messages: 92
Registered: February 2002
Member
Hi all,


I want to audit only one procedure in a package.
I don't want to use the 'audit execute on myPackage ' but something like 'audit execute on myPackage.myProc'.
The second clause is impossible.
Is their an other way to do it?


thk a lot!
Re: audit usage of procedure in a package [message #408928 is a reply to message #408922] Thu, 18 June 2009 06:12 Go to previous message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not possible, add logging in your code.

Regards
Michel
Previous Topic: audit index usage
Next Topic: ora-01950 no privileges on tablespace xxx
Goto Forum:
  


Current Time: Wed Oct 22 03:41:01 CDT 2014

Total time taken to generate the page: 0.14487 seconds