http://broersa.wordpress.com/   exec dbms_network_acl_admin.create_acl(acl => 'resolve.xml',description => 'resolve acl', principal => 'ABACUS', is_grant => true, privilege => 'resolve'); exec dbms_network_acl_admin.assign_acl(acl => 'resolve.xml', host => '*');    select  utl_inaddr.get_host_name('116.90.226.210') from dual; select  utl_inaddr.get_host_name('mail.abacusnepal.com') from dual;  select  utl_inaddr.get_host_name('127.0.0.1') from dual;       http://www.liberidu.com/blog/?p=246  DECLARE   acl_path  VARCHAR2(4000); BEGIN   SELECT acl INTO acl_path FROM dba_network_acls    WHERE host = 'host_name' AND lower_port IS NULL AND upper_port IS NULL; IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(acl_path,                                          'user_name','connect') IS NULL THEN     DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl_path,                                          'user_name', TRUE, 'connect'); END IF; EXCEPTION   WHEN no_data_found THEN     DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('ACL_name.xml',       'ACL description', 'user_name', TRUE, 'connect');     DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('ACL_name.xml','host_name'); END; COMMIT;

Leave a Reply