queried "select * from dba_network_acls" it only shows UTLB and not UTL and UTLA..
Hi,
I executed the following script which ran fine.
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'UTL_HTTP.xml', description=>'UTL_HTTP access ', principal=> 'HR', is_grant=>TRUE, privilege=>'connect');
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'UTLA_HTTP.xml', description=>'UTL_HTTP access ', principal=> 'SH', is_grant=>TRUE, privilege=>'connect');
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'UTLB_HTTP.xml', description=>'UTL_HTTP access ', principal=> 'FJH', is_grant=>TRUE, privilege=>'connect');
--DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => 'UTL_HTTP.xml',principal => 'FOO',is_grant => true, privilege => 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl=>'UTL_HTTP.xml',host=>'10.189.172.44');
I executed the following script which ran fine.
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'UTL_HTTP.xml', description=>'UTL_HTTP access ', principal=> 'HR', is_grant=>TRUE, privilege=>'connect');
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'UTLA_HTTP.xml', description=>'UTL_HTTP access ', principal=> 'SH', is_grant=>TRUE, privilege=>'connect');
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'UTLB_HTTP.xml', description=>'UTL_HTTP access ', principal=> 'FJH', is_grant=>TRUE, privilege=>'connect');
--DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => 'UTL_HTTP.xml',principal => 'FOO',is_grant => true, privilege => 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl=>'UTL_HTTP.xml',host=>'10.189.172.44');
0