Tips:

Row Level Security Access

Using the General Security Access form

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

Salary Data

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

Select Add in SECTION D: ROW LEVEL SECURITY > SALARY ACCESS.

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

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

Select Add and enter the values that best include the data to which you need access in SECTION D: ROW LEVEL SECURITY.

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: Section 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: Select 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: Select 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: Select 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: Select access to multiple departments, all their projects, and one additional project.