Switch off database network ACL's



This is a reminder for me as much as anything - the damn acl's that control what traffic can be allowed from 'inside' the database are a real pain and sometimes its nice just to switch the things off - here is the code block to do that

begin
 dbms_network_acl_admin.create_acl(
 acl =>         'norules.xml',
 description => 'everything allowed',
 principal =>   'PUBLIC',
 is_grant =>    true,
 privilege =>   'connect'
 );
 DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
 acl =>         'norules.xml',
 principal =>   'PUBLIC',
 is_grant  =>   true,
 privilege =>   'resolve'
 );
 dbms_network_acl_admin.assign_acl(
 acl =>         'norules.xml',
 host =>        '*'
 );
end;
/

commit;

Not recommended of course but sometimes its nice to just quickly do this to get you moving rather than messing about wondering what are the specifics of what is being blocked.

Comments