Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find the description of an ACL

UW (Germany)Oct 24 2025

When I create a new ACL I can provide a description for it like

BEGIN 
  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL( 
  acl => 'us-example-com-permissions.xml', 
  description => 'Network permissions for *.us.example.com, created by R.S. Oct 2025', 
  principal => 'SCOTT', 
  is_grant => TRUE, 
  privilege => 'connect'); 
END;

But when I query the view DBA_NETWORK_ACLS there is no column for the description (at least in Oracle 19c). Is the description of an ACL stored anywhere in the database? Can it be retrieved with an SQL-Query?

This post has been answered by Solomon Yakobson on Oct 24 2025
Jump to Answer
Comments
Post Details
Added on Oct 24 2025
2 comments
109 views