How to extract tables that are accessible to specific role

sushmitha2
Tera Contributor

‎09-26-2023 09:40 PM

Is there a way to extract all the table names that are available to ITIL users(itil role).

0 Helpfuls
  • 161 Views
1 REPLY 1

Community Alums
Not applicable

‎09-26-2023 09:50 PM

Hi @sushmitha2 ,

You can use a report for this use case!!

You can report base on table sys_security_acl_role

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

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.

0 Helpfuls