How To Install Dbms_network_acl_admin Package In 11g

2/7/2018by

Using DBMS_NETWORK_ACL_ADMIN • Examples Example1 Grant the connect and resolve privileges for host www.us.oracle.com to SCOTT. BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl =>'www.xml', description =>'WWW ACL', principal =>'SCOTT', is_grant =>true, privilege =>'connect'); DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl =>'www.xml', principal =>'SCOTT', is_grant =>true, privilege =>'resolve'); DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl =>'www.xml', host =>'www.us.oracle.com'); END; / COMMIT; Example 2 Grant the resolve privilege for www.us.oracle.com to ADAMS. Since an ACL for www.us.oracle.com exists already, just add the privilege for ADAMS. BEGIN DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl =>'www.xml', principal =>'ADAMS', is_grant =>true, privilege =>'resolve'); END; / COMMIT; Example 3 Assign the ACL www.xml to www-proxy.us.oracle.com so that SCOTT and ADAMS can access www-proxy.us.oracle.com also. BEGIN DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl =>'www.xml', host =>'www-proxy.us.oracle.com'); END; / COMMIT; Example 4 Unassign the ACL from www.us.oracle.com so that no access to www.us.oracle.com is allowed. BEGIN DBMS_NETWORK_ACL_ADMIN.UNASSIGN_ACL(host =>'www.us.oracle.com'); END; / COMMIT; Example 5 The in the DBMS_NETWORK_ACL_UTLILITY package returns all the domains a host belongs to. It can be used in conjunction with the in this package to determine the privilege assignments affecting a user's permission to access a network host.

Dell Optiplex Gx240 Drivers Audio. The function in the DBMS_NETWORK_ACL_UTILITY package returns the level of each domain and can be used to order the ACL assignments by their precedence. Table 80-2 ADD_PRIVILEGE Function Parameters Parameter Description acl Name of the ACL. Ashiqui Te Loan Mp3 Song Download on this page. Relative path will be relative to '/sys/acls'. Principal Principal (database user or role) to whom the privilege is granted or denied. Case sensitive.

How To Install Dbms_network_acl_admin Package In 11gHow To Install Dbms_network_acl_admin Package In 11g

Comments are closed.