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

Advertisement

The Power of the Oracle Trace Files

Posted on by Ahmed Abdel Fattah

Although I had different topics planned for my first blog, but I just received this client issue this morning, and I decided to share it with you to explain how to take advantage of the powerful information contained in the oracle trace files. What is the issue? I received a call from one of my … Continue reading The Power of the Oracle Trace Files