Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation

Understanding row-level security

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 ...