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