Classified Columns
A classified column hides a sensitive value, like a salary, from everyone except the people you give access to.
1. Create a classification type
- In Designer, go to Maintenance → Data Classification.
- Under Add a classification type, type a title, such as "Financial", and click Add.
- Add a Description.
- Click Save.
2. Classify a column
- Open the table in Designer and edit the column.
- Under Data classification, pick a type.
- Give access (see step 3).
- Save the column.
A classified column with no access given can't be read by anyone.
These columns can't be classified: system and default columns, secret columns, Computed and Subquery columns, and Multi-lookups.
3. Give access
Each person or group gets three switches:
| Switch | Lets them… |
|---|---|
| Read | see the value |
| Edit | see, enter, change and clear the value |
| Create | enter the value on a new item only, without seeing it afterwards |
Per column, for access on every item: under Per column, use Add a user or group.
Per row, for access only on items that name them: under Per row, use Add a User column. Per-row access is Read and Edit only, and starts once the item is saved.
For per row, pick either:
- a User column that is classified itself, or
- Created By.
Why the User column must be classified
Whoever is named in the User column gets access. If anyone could edit that column, they could put their own name in it and see the value. Classifying it means only the people you give Edit on it can change who's named.
Created By doesn't need classifying, because nobody can change it. It's always whoever created the item.