What are security join tables?

What are security join tables? Why is it necessary to refresh SJT processes?

PeopleSoft system stores security data in user and transaction Security Join Tables. (SJTs).

User SJTs are:

- SJT_OPR_CLS: Contains the User IDs with their data permission lists.

- SJT_CLASS_ALL: Contains the data permission information for all the data permission lists that are given data access on the ‘Security by Dept Tree’ page or ‘Security by Permission List’ page.

Transaction SJTs are:

- SJT_PERSON: Contains transaction data for the people (employees, contingent workers, Person of Interest). It has row level security attributes (SetID, DeptID etc) for all the employees.

- SJT refresh processes have to be run to keep security data (in user and transaction SJTs) up to date so that the system enforces data permission using the most current information.
Flow of setting up application security
When a new functionality needs to be provided access for users, then roles and permissions are used. The functionality is...
Department security
If the direct reports are also in department 3 then they can see the data for employees in department 2 and 1 only...
Security by Department tree
Security by department tree defines which setid and deptid a permission list has access to....
Post your comment