11.6.5 Testing Enhanced Salary Review Page

At runtime, authorization schemes and row-level data-security work together to grant data and feature access based on a user's role.

With all your changes in place, when a manager like JONES logs in, he now sees the Salary Review page in his navigation menu as shown below.

Figure 11-26 Now Managers Like Jones See the Salary Review Page

Description of "Figure 11-26 Now Managers Like Jones See the Salary Review Page"

Opening the page, as shown below, JONES sees the four reports that either report directly to him, or to one of the managers who work for him. The data security policy automatically restricts the data JONES can see. Also, the Sal and Comm columns are read-only as requested.

When an HR Representative like SUSAN logs in, the page continues to let her see all employees and edit their salary and commission as before.

Figure 11-27 Data Security Ensures Jones Sees Only Own Staff Members

Description of "Figure 11-27 Data Security Ensures Jones Sees Only Own Staff Members"