So far we have discussed security access being controlled using permission lists and roles to specify which application pages can be accessed by users.
In addition to the page security, PeopleSoft offers another level of security called Row level security. This method is useful to control access to specific rows of data using either specific User IDs or permission lists.
To understand this concept, let's continue our example of Anton, who can enter vouchers in the Accounts Payable module. We already saw configuration options that allowed us to limit his system access to voucher entry pages. But can we restrict his access to vouchers for only one Business Unit, (BU) say US001? We certainly did not see such options while configuring user profiles, roles, or permission lists. This is where row-level security comes in.
If we wish to limit Anton to seeing vouchers in the system for US001 BU alone, we essentially want to limit his access to only those database rows...