Access Control Lists
SQL> @acl
Access Control Lists
DBA_NETWORK_ACLS
HOST LOWER_PORT UPPER_PORT ACL ACLID
-------------------------------------------------- ---------- ---------- -------------------------------------------------- --------------------------------
* /sys/acls/power_users.xml 0A8F74596A85633FE073318802A1EB0A
ldap_serv.noon.com 389 389 /sys/acls/ldap_acl.xml 0EAA2F45B8491AF4E053318802A1424A
2 rows selected.
DBA_NETWORK_ACL_PRIVILEGES
ACL ACLID PRINCIPAL PRIVILE IS_GR INVER START_DATE END_DATE
-------------------------------------------------- -------------------------------- -------------------- ------- ----- ----- -------------------- --------------------
/sys/acls/ldap_acl01.xml 0EAA2F45B8491AF4E053318802A1424A GENERAL_X connect true false
/sys/acls/ldap_acl01.xml 0EAA2F45B8491AF4E053318802A1424A GENERAL_X resolve true false
/sys/acls/power_user.xml 0A8F74596A85633FE073318802A1EB0A APEX_040200 connect true false
/sys/acls/power_user.xml 0A8F74596A85633FE073318802A1EB0A DEVELOP_001 connect true false
4 rows selected.
DBA_WALLET_ACLS
no rows selected
prompt
prompt Access Control Lists
prompt
prompt
col HOST for a50
col ACL for a50
prompt DBA_NETWORK_ACLS
prompt
select *
from DBA_NETWORK_ACLS
order by host;
col ACL for a50
col PRINCIPAL for a20
col PRIVILEGE for a7
col IS_GRANT for a5
col INVERT for a5
prompt
prompt
prompt DBA_NETWORK_ACL_PRIVILEGES
prompt
select * from DBA_NETWORK_ACL_PRIVILEGES order by principal;
col WALLET_PATH for a50
prompt
prompt
prompt DBA_WALLET_ACLS
prompt
select * from DBA_WALLET_ACLS;