Database Security Products (MOSC)

MOSC Banner

Oracle 12c ACL Odd behaviour.

edited Oct 4, 2016 12:28PM in Database Security Products (MOSC) 4 commentsAnswered


Hi,

I'm setting up my first 12c database. On creating the ACL I experienced some unexpected behaviour.

So for example I do the following:

BEGIN
  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
     acl          => 'sasa-permissions.xml',
     description  => 'Network permissions for sasa.net',
     principal    => 'CONNECT',
     is_grant     => TRUE,
     privilege    => 'connect');
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
  acl => 'sasa-permissions.xml',
  principal => 'CONNECT',
  is_grant => true,
  privilege => 'resolve');
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
  acl => 'sasa-permissions.xml',
  principal => 'CONNECT',
  is_grant => true,
  privilege => 'connect');
END;
/

begin
  dbms_network_acl_admin.assign_acl (
  acl => 'sasa-permissions.xml',
  host => 'localhost');
end;
/

Now first odd behaviour is that in 11g I would normally check the following to make sure the ACL is created:

Tagged:

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