Database Security Products (MOSC)

MOSC Banner

queried "select * from dba_network_acls" it only shows UTLB and not UTL and UTLA..

edited Nov 18, 2013 6:31AM in Database Security Products (MOSC) 1 commentAnswered ✓
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');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center