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;
Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s