DBA Hub

📋Steps in this guide1/1

Get ACL details in database

set lines 200 COL ACL_OWNER FOR A12 COL ACL FOR A67 COL HOST FOR A34 col PRINCIPAL for a20 col PRIVILEGE for a13 select ACL_OWNER,ACL,HOST,LOWER_PORT,UPPER_PORT FROM dba_network_acls;

oracle configurationintermediate
by OracleDba
14 views
1

Get ACL details in database

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
set lines 200
COL ACL_OWNER FOR A12
COL ACL FOR A67
COL HOST FOR A34
col PRINCIPAL for a20
col PRIVILEGE for a13
select ACL_OWNER,ACL,HOST,LOWER_PORT,UPPER_PORT FROM dba_network_acls;
select ACL_OWNER,ACL,PRINCIPAL,PRIVILEGE from dba_network_acl_privileges;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!