Roles and ACL

[AJ5]

Hi Experts,

I would like to find a way to report on the Roles and ACLs linked to a particular table. When I look

at the table security, I can see the list of all the ACLs, but it doesn’t show me the option to add roles column that are linked to the operations, unless I click on each ACLs and look at them

individually. Any better way to find out?

[JP - Kyndryl]

Hi AJ5,

I would use the  security_acl_detail  database view to report.

[Basheer]

Hi @AJ5 ,

Navigate to application navigator and type in security_acl_detail.list

You can see something as below which has the ACL name as well as the role name.

[Johns Marokky]

Hi @AJ5 ,

There are two ways by which we can achieve this.

One is using the direct table --> sys_security_acl_role (Which gives the ACL name and what roles are associated and we can even do the dot walking to get more fields in the report)

Another way is using the database view as mentioned above --> security_acl_detail

Note: In both cases for an ACL if there are multiple roles associated, each role will be considered as an individual record in these tables

Mark helpful if it helps in solving your query.

Regards,

Johns

[AJ5]

Thank you for all your responses. I just wanted to know if there was any easy way to report on tables that will show all the roles and permissions.