Prerequisites to debug PL/SQL in Oracle Database 12c with SQL Developer

(Picture by Nata-Ap [CC BY-SA 3.0], via Pixabay) Why I am so obsessed with ACL ? I have no idea ! Actually it is the other way round, ACL are hunting me. This morning, I helped a fellow developer who wanted to debug his new PL/SQL procedure with SQL Developer. His first attempt generated errors […]

Read More

Fun with Access Control Entries in Oracle 12cR1 – Part 2 : ACE and Data Pump

(Picture by Tiia Monto [CC BY-SA 3.0], via Wikimedia Commons) As explained in my previous blog post, in an attempt to develop a solid script to handle ACE (who says I am a quibbler ?), I also played with Data Pump to export and import ACE/ACL in Oracle 12cR1. I found out that OBJECT_PATH=NETWORK_ACL exists […]

Read More

Fun with Access Control Entries in Oracle 12cR1 – Part 1 : A way to extract ACE without Data Pump

(Picture by Miguel Hermoso Cuesta (Own work) [CC BY-SA 3.0], via Wikimedia Commons) My work environment has approximately 100 production databases and 400 non-production databases. We developed a self-service web application (with APEX 😉 ) that offers developers the right to clone databases. We have some development databases with ACL, concerning development hosts, which are […]

Read More