Check permissão DBA_NETWORK_ACL_PRIVILEGES e DBA_NETWORK_ACLS Formatando visualização
|
1 2 3 4 5 |
column ACL format a25; column PRINCIPAL formata20; column PRINCIPAL format a20; column PRIVILEGE format a20; column HOST format a20; |
Checando DBA_NETWORK_ACL_PRIVILEGES
|
1 2 3 4 5 6 |
SQL> select acl,principal,privilege,is_grant from DBA_NETWORK_ACL_PRIVILEGES; ACL PRINCIPAL PRIVILEGE IS_GR ------------------------- -------------------- -------------------- ----- /sys/acls/ACL_TI.xml TI connect true /sys/acls/ACL_TI.xml TI resolve true |
Checando DBA_NETWORK_ACLS
|
1 2 3 4 5 |
SQL> select acl,host,lower_port,upper_port from DBA_NETWORK_ACLS; ACL HOST LOWER_PORT UPPER_PORT ------------------------- -------------------- ---------- ---------- /sys/acls/ACL_TI.xml * |