OraFAQ Forum: Security » audit usage of procedure in a package

Home » RDBMS Server » Security » audit usage of procedure in a package (ORACLE 11)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

audit usage of procedure in a package [message #408922]

Thu, 18 June 2009 05:45

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!

Report message to a moderator

Re: audit usage of procedure in a package [message #408928 is a reply to message #408922]

Thu, 18 June 2009 06:12

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is not possible, add logging in your code.

Regards
Michel

Report message to a moderator

Previous Topic:	audit index usage
Next Topic:	ora-01950 no privileges on tablespace xxx

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 20 08:51:40 CDT 2026