Snoeflake integration ACL for sys_dictionary.sys_id
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hi, I am receiving this error as below, in the documentation from snowflake. they need access to sys_dictionary.sys_id, but I can not set this up as it is not selectable.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
you cannot do anything here.
Exposing sys_id on Dictionary table is not recommended.
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hi @NaBian ,
Since sys_id on sys_dictionary cannot be individually selected via ACL UI, your best approach is to ensure the connector user has broad access (read/query) to the entire table, effectively bypassing per field restrictions....
Create or configure a dedicated ServiceNow user for the connector.
Assign roles or ACLs granting this user read, query_match, and query_range access on the full sys_dictionary table, not just on selectable fields....
Likewise, ensure similar access rights on sys_db_object, sys_glide_object, and sys_table_rotation. and confirm that no ACL rules unintentionally restrict access to metadata tables.
If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.
Kaushal Kumar Jha - ServiceNow Consultant - Lets connect on Linkedin: https://www.linkedin.com/in/kaushalkrjha/