Disable Oracle 11g ACL

More as a reminder to myself. This can be found everywhere on the web. You should know this when setting up a development environment.
Connect as sys

 begin  
   begin 
     dbms_network_acl_admin.drop_acl( acl => ‘all-network-PUBLIC.xml’ ); 
   exception 
     when others 
     then 
       null; 
   end; 
   dbms_network_acl_admin.create_acl 
     ( acl         => ‘all-network-PUBLIC.xml’ 
     , description => ‘Network connects for all’ 
     , principal   => ‘PUBLIC’ 
     , is_grant    => true 
     , privilege   => ‘connect’ 
     ); 
   DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE 
     ( acl       => ‘all-network-PUBLIC.xml’ 
     , principal => ‘PUBLIC’ 
     , is_grant  => true 
     , privilege => ‘resolve’ 
     ); 
   dbms_network_acl_admin.assign_acl ( acl => ‘all-network-PUBLIC.xml’ , host => ‘*’ ); 
end; 
/ 
commit;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.