If you Login as ADMIN, you will have all the access to all the data
Id
Name
Product
SSN
Phone
Region
1
abc
xyz
100
20
US East
2
dfr
123
200
30
US West
If you login as USER,
the table structure should be same and I should not be able to see the SSN and Phone Info and instead of blank space I need to show "No access" message
Id
Name
Product
SSN
Phone
Region
1
abc
xyz
No Access
No Access
US East
2
dfr
123
No Access
No Access
US West
I can get the desired result by using a condition at the UI level, but I don't want to go in that path, because we need to educate all the app developers to write the function at the UI side for many number of columns to restrict the access, that's going to be a hell of a challenge.
So, is there any way we write some function at the script level to display the custom text, instead of using function in UI side to display custom text?