Search Record and Row Level Security

Using PeopleSoft row-level security views enables you to restrict users from seeing certain rows of data. You can restrict data by:

• User, by using the OPRID field.
• Primary permission list, by using the OPRCLASS field.
• Row security permission list, by using the ROWSECCLASS field.

To implement row-level security through a security view:

1. In Application Designer, insert one of the three row-level security fields (OPRID, OPRCLASS, ROWSECCLASS) into the record definition.
2. Configure the field as a Key, but not a List Box Item.
3. Save the record and build the view.
4. Use the record as the search record or query security record.

Now, when the user searches, the system dynamically adds a WHERE clause — that incorporates the security field — to the search SELECT statement. The value of the security field is based on the current user.