Report that shows roles that grant access to a table

[Alan42]

Is there a delivered report that shows which roles grant access to a table.   I do security administration for our ERP and the ability to easily look that granular access up comes in very handy.  I'm not seeing a way to do it in ServiceNow and haven't been able to find any posts asking for it.    

[JaeggerLegane13 · Accepted solution]

I think your closest bet would be to pull a list on the Access roles table.

It will show the ACLs to which each role has access and thus also the tables. 
Note that the list will also contain specific fields on the table so you may want to exclude those afterwards in excel to have a clean list.

Steps:
1. Open filter navigator and type sys_security_acl_role.list
2. Search for the related role

Example:

[Bert_c1]

Look at ACLs in your instance. By table and fields.

https://docs.servicenow.com/bundle/vancouver-it-service-management/page/product/change-management/ta...

[AndersBGS]

Hi @Alan42 ,

My initial though would be to create a database view where you combine sys_security_acl_list together with sys_security_acl_role. This will give you the role naming together with the CRUD rules from the ACL list.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders