Row-Level Security

To establish security, you must first decide which level of security to establish throughout the system, which key fields to secure, and whether security is defined through user IDs or permission lists. With row-level support, you can implement security to provide individual users or permission lists with access to a table, but you do not have to provide access to all rows in the table. This type of security is typically applied to tables that hold sensitive data. For example, you can implement row-level security in PeopleSoft Resource Management to restrict project business units that are available for assignments and service orders.

The PeopleSoft system determines which data permissions to grant to a user by examining the primary permission list and row security permission list. The permission list that is used varies by application and data entity, such as employee, customer, or business unit.