Is there a way to find out what tables a role has access too?

[Brian189]

I would like to be able to select a role and find out which tables that role has access to.  I have not found an easy way in reporting to list out the tables that a role is allowed to access and was wondering if anyone knows how to do that?

[Pradeep Sharma]

Hello Brian,

You can report base on table sys_security_acl_role

Ofcourse this will not give the data which has blank role on the table.

[Brian189]

Thanks Pradeep, I looked at reports and did not see the sys_security_acl_role table listed, how do I get that to show up in reports?

Brian

[Pradeep Sharma · Accepted solution]

Thanks Brian for the update. System tables are, by default, restricted from the Reporting module.

If you must report on a system table, you can add it to the glide.ui.permitted_tables property. Navigate to System Properties > UI Properties and locate the property labeled List of system tables (beginning with "sys_", comma separated), that are reportable. By default, system tables are not reportable. Proceed with caution.

Reporting on System Tables - ServiceNow Wiki

[Brian189]

Thanks Pradeep, that worked.   I appreciate the help!

Brian