Skip to Main Content
  • Questions
  • How can I audit the individual functions/procedures inside package?

Breadcrumb

Dev Live Dev Intro

This month we are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

Question and Answer

Chris Saxon

Thanks for the question, Jery.

Asked: July 10, 2020 - 12:08 pm UTC

Answered by: Chris Saxon - Last updated: July 10, 2020 - 2:35 pm UTC

Category: Database Administration - Version: Oracle Database 12.1.0.2

Viewed 100+ times

You Asked

Oracle Audit sentence:

audit execute on [package] by access;

How Can I Do something like this?

audit execute on [package.function] by access;

I need to audit execution of functions inside packages with Oracle Audit options.

Is it possible to audit arguments sent to this functions too?

And Is it possible to Select this info of SYS.AUD$ or other Views

Best regards,

Jery

and we said...