Tips:

Row Level Security Access

Using the Express Security Access form

For the data that you need to see, make the corresponding selections below on the Express Security Access form.

Salary Data

Will you be...authorized to see employee payroll data in NUFinancials and Cognos reports?

Select Salary Access in the Cognos Report Access section.

Selections for Salary Access.
Figure 1: Selection for Salary Access
Financial Data

Will you be...authorized to see financial data?

Enter the values that best include the data to which you need access in the ROW LEVEL SECURITY section.

RLS works with the NU Department Tree. The logic of the tree is inclusive from the top down. Tree Nodes identify organizational units in the University. Examples:

If you specify a node on the tree, you gain access to all departments and projects below it. Likewise, if you specify a department, you also gain access to all projects below it. If necessary, you may list departments and projects separately. However, list projects separately only if departments already listed do not own the project. Likewise for departments and tree nodes above them.

Examples are shown below.

Selections for financial data access
Figure 2: Selections for financial data access
Row Level Security Examples

1. Access to XYZ node and to all departments and projects within it.

Click Add and enter the Tree Node name.
Figure 2A: Access to tree node and all departments and projects within it

2. Access to department 7777777 and all projects within it. DeptIDs are seven digits.

Click Add and enter the 7-digit Department ID.
Figure 2B: Access to department and all projects within it

3. Access to project 88888888 only. Project IDs are eight digits.

Click Add and enter the 8-digit Project
 ID.
Figure 2C: Access to project only

4. Access to five departments and to all projects within them. Plus access to one additional project in another (unlisted) department.

Click Add and enter the 7-digit Department IDs. Do the same for the Project ID.
Figure 2D: Access to multiple departments, all their projects, and one additional project