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

Brian189 · ‎06-02-2017

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 · ‎06-02-2017

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

View solution in original post

Pradeep Sharma · ‎06-02-2017

You are very welcome Brian. Thanks for participating in the community!