My Oracle Support Banner

DBMS_NETWORK_ACL_ADMIN.CREATE_ACL Worked But Nothing In Dba_network_acls (Doc ID 1553074.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
Checked for Relevance on 16-Oct-2014

Symptoms

 Nothing in the dba_network_acl_privileges view after creating ACL.

Created ACL list as below.

 


BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl         => 'test.xml',
                                  description => 'ACL FOR test',
                                  principal   => 'TEST',
                                  is_grant    => true,
                                  privilege   => 'connect'
);
COMMIT;
END;
/


begin
 DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('TEST.xml','TEST',TRUE,'connect');
 commit;
end;
/

--------------------------------


select *
from sys.dba_network_acl_privileges

no row selected

 

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.