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:

[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:

[Alan42]

That seems simplest.  Is there a table for groups?    That would probably work even better.     

[JaeggerLegane · Accepted solution]

Unfortunately not without creating a database view.

[Alan42]

That did the trick and I can run a report that way.   Thank you.