5,124
Hi All,
I know I can control read/insert/mod/del permissions on a table level using permission sets. But what I want to do now is to limit modification on a specific field in a given table. I only want to allow mods for this field to SUPER users plus 2-3 more users. Please advise how to go about this.
*This post is locked for comments
Glad to help.
I think it's a very good idea! I think I am going to use the User Setup and add Boolean fields for any fields in different tables that require specific permissions. I have quite a few. Thank you Suresh!
When i want to control modifications to a field or record, i normally created a field on the user setup a boolean for that permission like ex.: WMS Manager... and i assign that permission to the users in the user setup and write code in the triggers of the field or table to check if the user has the permission.
If you don't like the idea of adding a field on user setup you can still control that using a function to access the permission set and check if that user has the specific permission in your example check if he has 'SUPER' role assigned if not error out.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (