Skip to content
March 20, 2013 / doganay

ORA-44416: Invalid ACL: Unresolved principal


Problem:

ORA-44416: Invalid ACL: Unresolved principal 'MYUSER1'


While:

Trying to add privilege.

Solution:

--We assume that myuser1 does not exist on DB and myuser2 does.
begin
DBMS_NETWORK_ACL_ADMIN.DELETE_PRIVILEGE (acl => '/sys/acls/myacl.xml',
principal => 'MYUSER1');

DBMS_NETWORK_ACL_ADMIN.DELETE_PRIVILEGE (acl => '/sys/acls/myacl.xml',
principal => 'MYUSER1',
is_grant => true,
privilege => 'resolve');

--If that was the only privilege, your acl is also dropped automatically, you must create it:
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => '/sys/acls/myacl.xml',
description => 'MYACL',
principal => 'MYUSER2',
is_grant => true,
privilege => 'connect');

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => '/sys/acls/myacl.xml',
principal => 'MYUSER2',
is_grant => true,
privilege => 'resolve');
end;
/
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: