today:
33
yesterday:
311
Total:
1,018,272

General DBMS_NETWORK_ACL_ADMIN

admin 2016.06.07 13:48 Views : 372

 SELECT host, acl,
     DECODE(
          DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE_ACLID(aclid, 'SCOTT', 'resolve'),
            1, 'GRANTED', 0, 'DENIED', NULL) privilege
     FROM dba_network_acls
    WHERE host IN
      (SELECT * FROM
         TABLE(DBMS_NETWORK_ACL_UTILITY.DOMAINS('www.us.oracle.com'))) and
      lower_port IS NULL AND upper_port IS NULL
   ORDER BY DBMS_NETWORK_ACL_UTILITY.DOMAIN_LEVEL(host) desc;


   HOST                         ACL          PRIVILEGE
   -------------------- -------------------- ---------
   www.us.oracle.com    /sys/acls/www.xml    GRANTED
   *.oracle.com         /sys/acls/all.xml
   *                    /sys/acls/all.xml  
No. Subject Author Date Views
106 ADD_PRIVILEGE (2nd STEP) admin 2016.06.07 373
» DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 372
104 DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 357
103 Access Control List (ACL) admin 2016.06.07 355
102 function get area admin 2016.06.08 345
101 How to set a proxy in UTL_HTTP admin 2016.06.07 341
100 CREATE_ACL (1st STEP) admin 2016.06.07 329
99 ACL 보기 admin 2016.06.07 324
98 Assign a network host to Access Control List admin 2016.06.07 321
97 CAPTCHA PLUG-IN admin 2016.05.27 314
96 Oracle 11g Access Control List for External Network Services admin 2016.06.07 310
95 영수증 2023 file admin 2024.01.04 295
94 FOR LOOP admin 2016.05.20 293
93 SUBSTR admin 2016.05.26 289
92 Validation to detect text in numeric field admin 2018.05.19 263
91 ROWNUM admin 2016.05.19 255
90 Change Admin PASSWORD admin 2018.07.31 251
89 VERY IMPORTANT admin 2018.06.26 250
88 How-To Document / Change a Logo in a Page Template admin 2016.04.16 248
87 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 247