today:
1,194
yesterday:
1,189
Total:
1,008,574

General DBMS_NETWORK_ACL_ADMIN

admin 2016.06.07 13:48 Views : 357

 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
86 FOR LOOP admin 2016.05.20 270
85 SUBSTR admin 2016.05.26 272
84 CAPTCHA PLUG-IN admin 2016.05.27 301
83 Access Control List (ACL) admin 2016.06.07 344
82 Oracle 11g Access Control List for External Network Services admin 2016.06.07 302
81 ACL 보기 admin 2016.06.07 311
80 CREATE_ACL (1st STEP) admin 2016.06.07 317
79 ADD_PRIVILEGE (2nd STEP) admin 2016.06.07 351
78 Assign a network host to Access Control List admin 2016.06.07 296
77 DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 344
» DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 357
75 APEX Web Services Proxy Settings admin 2016.06.07 362
74 How to set a proxy in UTL_HTTP admin 2016.06.07 321
73 function get area admin 2016.06.08 329
72 Membership Management admin 2016.06.09 436
71 control break admin 2016.06.25 399
70 SQL admin 2016.07.15 398
69 JavaScript for Member List admin 2016.08.17 436
68 APEX Password Change admin 2016.08.26 463
67 SQL Basics - Lesson 1 - Introduction admin 2017.06.17 100