Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel6
outlinefalse
stylenone
typelist
printablefalse

...

This can be an excel you upload into your workbook or a data source you connect your workbook to. At the very least, the security assignments must include (1) Active Directory ID Current and (2) key field that you want to assign.

Example By Department:

View file
nameExample Row Level Security Per Person.xlsx

Department Code

Department

Identity Active Directory ID Current

Employee Display Name AsOf

003009

9 EAST CRC UNIT

rcmadden

Russia Madden

000382

ADV CELL THERAPY LABORATORY

rcmadden

Russia Madden

000429

CAMPUS PLANNING OFFICE

saparnell

Sarah Parnell

003077

CARDIOLOGY CLINIC

saparnell

Sarah Parnell

950000A

CHANCELLOR

saparnell

Sarah Parnell

...

Navigate to the Data Source tab for your Security Assignments. Add a filter for Security Username Check = True.

image-20240319-231622.png

Note: If you are not in your Security Assignment data source do this step last b/c you will not be able to see any data after applying this filter.

...

Clear your worksheet if you have not yet.

...