Peoplesoft Row Level Security Example

One of the topics which needs attention in PeopleSoft Security is Row level Security.In Organizations, we have different people occupying different roles and each rolehas its own responsibilities.A Single person may handle two roles which he needs to perform in the organization, say Employee role and Manager role etc. Through Row level security data is secured such that it will be viewed by only authorized users.Let's consider a college which offers courses in different Domain. To make it more simple lets consider there is Computer Science Department and Information Technology Department and Civil Department.And below are the entitiesStudentsAssistants ProfessorsProfessorsHead of the DepartmentAs we know there are certain subjects which are common between Computer Science Department and IT Department, same professor can teach same subject for both of the Departments. Some Professors only teach CSE or only teach IT.Let's say Professor A teaches CSE and IT DepartmentsProfessor B teaches only CSE Department.From the above scenario, Professor B can access the records of students only from CSE Department and Professor A can access records of students from both CSE and IT Departments. This is nothing but making data available to authorized users by encapsulating unwanted data. The term we use in PeopleSoft for this is 'Row Level Security' where each entry in the database table is considered as a row of data.If we are familiar with Set Theory in Mathematics, its the same concept used here. Below is the diagram which shows the level of access each Professor has to the data in the system.

The gloves are off and Sonic and his rivals are gearing up for an intense new head-to-head competition exclusively on the PSP® (PlayStation® Portable) system. This sequel to Sonic’s 2D action platformer features all-new “jostling” controls for tighter competition and a brand new Battle mode that allows two players to jump into six. This sequel to Sonic’s 2D action platformer features all-new 'jostling' controls for tighter competition and a brand new Battle mode that allows you and a friend to jumpThe gloves are off and Sonic and his rivals are gearing up for an intense head-to-head competition exclusively on the PSP.

The Row Level Security Paradigm Most database administrators understand the concept of row level security. Returning to the payroll data example, all detailed compensation data on the employees of an organization is stored in the same table(s) within the database. To do otherwise would greatly complicate the implementation of payroll applications.

PeopleSoft applications implement row-level security by using a SQL view that joins the data table with an authorization table. When a user searches for data in the data table, the system performs a related record join between the view and the base table rather than searching the table directly. The view adds a security check to the search, based on the criteria you’ve set up for row-level security. For example, to restrict users to seeing data from their own department, the view would select from the underlying table just those rows where the DEPTID matches the user’s DEPTID.