sys_history_set table - can we give access to user with snc_internal role

[AnshikaB]

I have a user who is having snc_internal role. Now i want that user to be able to access the sys_history_set table. As i want to create a module on this table that will only open the records related to a particular table.

can anyone help me out in this?

[Deepak Shaerma · Accepted solution]

Hi @AnshikaB 

For best practise - you cannot rely on the snc_internal role alone, as this is a protected system table. Doing so would allow every logged-in user to see the history of records. Instead, create a specific role.

You must create a new ACL. (You need security_admin role for creating a new ACL)

• Type:record

• Operation:read

• Name: sys_history_set | None

Happy to help! ‌‌
To help others in the community find this solution, kindly mark this response as the Correct Answer ‌‌ and Helpful‌‌.
Warm Regards,
Deepak Sharma
Community Rising Star 2025

[Deepak Shaerma · Accepted solution]

Hi @AnshikaB 

For best practise - you cannot rely on the snc_internal role alone, as this is a protected system table. Doing so would allow every logged-in user to see the history of records. Instead, create a specific role.

You must create a new ACL. (You need security_admin role for creating a new ACL)

• Type:record

• Operation:read

• Name: sys_history_set | None

Happy to help! ‌‌
To help others in the community find this solution, kindly mark this response as the Correct Answer ‌‌ and Helpful‌‌.
Warm Regards,
Deepak Sharma
Community Rising Star 2025

[Deepak Shaerma]

@AnshikaB 
Happy to help! If this resolved your issue, kindly mark it as the correct answer ✅  and Helpful 👍 and close the thread 🔒 so others can benefit too.
Warm Regards,
Deepak Sharma
Community Rising Star 2025

[Ankur Bawiskar · Accepted solution]

@AnshikaB 

Not recommended to give internal users access to system table "sys_history_set"

It contains all the audit details for records

If you still wish to give then check table level READ ACL

Note: Remember that table has reference fields as well, so please check if your user has read access to the tables being referred by those reference fields 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏