Skip to content
July 28, 2011 / doganay

ALL ACL DROP

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

 

Hi,

 

You can drop all acls on the database like this:

 

begin
 for i in (select distinct acl from dba_network_acls)
 loop
  begin
   DBMS_NETWORK_ACL_ADMIN.DROP_ACL(acl => i.acl);
   commit;
   exception
    when others then
     null;
  end;
 end loop;
end;
/

try and pray 🙂

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

%d bloggers like this: