By default, when you give Oracle PeopleSoft Query users access to a record definition, they can access all the rows of data in the table that were built using the associated record definition.

 

In some cases, though, you may want to restrict users from seeing some of those data rows.

 

For example, you may not want your human resources staff to access compensation data for vice presidents or above. That is, you want to enforce the row-level security feature that is offered by many PeopleSoft applications.

 

Row-level security enables users to access a table without accessing all rows on that table. This type of security is typically applied to tables that hold sensitive data.

 

In this topic, you will review how to enforce row-level security.


Table of Contents