Auditing Individual Functions/Procedures inside a PL/SQL Package

Posted on by Ahmed Abdel Fattah

I got this question from one of my clients:How can I Audit Individual Functions/Procedures inside a PL/SQL Package?. Let us build a quick demo: This is just a sample package Let us try to enable this type of auditing using the following command:audit execute on scott.emp_pack.CreateEmp by access;I got the following error: As per Oracle … Continue reading Auditing Individual Functions/Procedures inside a PL/SQL Package