Oracle Database provides classic database security such as row-level and column-level secure access by database users. It also provides fine-grained access control for table data and for resources in Oracle XML DB Repository, for secure access by Oracle Fusion users (who are not necessarily database users).
There are thus three dimensions: (1) which users can (2) perform which operations (3) on which data. We speak of :
1. principals,
2. privileges
3. objects.
You can make use of following views for seeing the information of all the ACLs in the system.
select * from dba_network_acls;Continue reading “ACL ddl script”
select * from dba_network_acl_privileges;