How do I alter data display based on security?

mom22 — Tue, 27 Aug 2019 17:07:45 GMT

I have a table that displays employee data, some of which is sensitive. We want to hide the employee name for users who don't have the proper security. I already have the following datasources. I am just not sure how to link them together to get the results I want.

Employee Data:
Name	Salary	PayGroup
Jane Doe	20000	1
John Doe	15000	2
Jim Smith	10000	3
Joe Shmoe	5000	4
Tom Thumb	25000	1

Current User Name:

UserName

=USERNAME()

User Security Info:
Username	PayGroup
mydomain\Donald	1
mydomain\Donald	2

I have 2 users in my example - Donald and Nancy. When they view the report, the table should look like so:

User Donald should see:
Employee Name	Salary
Jane Doe	20,000
John Doe	15,000
Tom Thumb	25,000
*****	15,000

User Nancy should see:
Employee Name	Salary
*****	75,000

Any ideas?

topic How do I alter data display based on security? in Developer

How do I alter data display based on security?