REST Access to sys_dictionary Fields

[stevec_]

We have created a REST role which is to have access to the sys_dictionary table so it can determine field types for tables and can preserve typing of retrieved data. It seems all is well except for the access to the internal_type field. It is never retrieved. Even when we impersonate a user with that role nothing is displayed in the "Type" column when we use the "sys_dictionary.list" view.

We have creates a "data_exchange" role and added the role to the following ACLs:

• grant read operation access to the sys_dictionary object.
• grant read operation access to the sys_dictionary.* object.
• grant read operation access to the sys_db_object object.
• grant read operation access to the sys_db_object.* object.

Any ideas as to other ACL settings our "data_exchange" role needs to access the "internal_type" field and maybe other fields our REST users may not be accessing?

[Mike Allen · Accepted solution]

Type is a reference of the table 'sys_glide_object'.   Maybe you need a read on that table to see the values?

[stevec_]

This did the trick. The "internal_type" field is now being returned to JSON REST requests for that role.

Thanks for the prompt reply Mike!