How to give access to view table schemas without making user an admin

[TrenaFritsche]

Is there a way to give access to Show Schema to non-admins?   I tried to create a custom module that lists table names and has the a button to use a UI Action that the Show Schema Map link on the table page uses thinking that I can give certain people the role that this new page has.   When I use it, it works fine, but when I impersonate that person who would use it, it displays the page, but does not show any tables.   Any thoughts on how to enable a graphic view of the table schema without providing admin access?

[Community Alums]

Can I ask where you found out that personalize_dictionary allows for this?  I can't find anything on the docs site with more details.

[Michael Ritchie]

In these situations I look at the ACLs linked to the records.  In the case of sys_dictionary, the personalize_dictionary has read access to those records which are queried when using the Schema Map.

[Kalaiarasan Pus]

I had investigated on this similar long back and it seemed difficult to get this working properly without admin access.

This might sound a little stupid, but I would instead advise you to take the screenshots of the table schema that people might be interested in and keep them on Sharepoint/any repositories. At-least we don't often add fields very often and it was the easiest next best thing that we settled on.

[apjohn2 · Accepted solution]

I just had this question come up for me in my company. An IT Networking manager for some reason decided to get trained up in using Tableau, apparently with the exclusive point to get data out of servicenow into Tableau for reporting reasons. As a result he asked me for access to view all table schema. I'm not about to give him full admin rights, so this was how I solved it:

1. Logged into our dev instance w/ full admin
2. Created a new user, which I named 'roadmin' (as in read-only admin)
3. Added two roles to this user: admin and snc_read_only
4. In a separate browser, logged into our dev instance as 'roadmin'
5. Verified I could see everything an admin can see, including all tables, schema, etc., but I could not edit any record on any table, anywhere

More about the snc_read_only role can be found here.

I hope this helps someone. Thank you.