Description
Overview
Sometimes it is required to find out which ACL are attached with a particular role , while enabling the debug could be an option it could also be found out using the sys_security_acl_role table , which ACLs have which role associated with them in an altogether different table. This could be fairly useful in reporting.
Subject
sys_security_acl_role table can help identify the ACLs which have a particular role associated with them.
Example
If it is required to find out how many ACLs have the ITIL role associated with them searching on the table sys_security_acl_role in the role column for ITIL will return the required answer.
Additional Information
Reporting can be done based on table sys_security_acl_role and it has to be noted that this will not give the data of ACLs which has blank role on the table.