software development, devops, and other drivel
Tree lined path

User Security Join Table (SJT) Jobs

All of the SJT (Security Join Tables) jobs that that joins security information from other tables in the database into a temporary table on the application server for use in business rules.

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.

TRANS_SJT_REFRESH: This deals specifically with security that is setup on the transaction tables and if a security object changes that modifies access to transaction data that is needed to run this process.

SJT Tables:

Transaction security tables

SJT_PERSONContains 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_PERSON_USFStores person related transaction data for USF installations.
SJT_DEPTStores department related transaction data.
HRS_SJT_JOStores job opening related transaction data.

User security tables

SJT_CLASS_ALLThe row security access assigned to a permission list (role based or row security). It contains all the data permission information for all the permission lists that are given data access on the Security by Dept Tree page or Security by Permission List page.
SJT_OPR_CLSStores which user profiles are assigned which permission lists. Contains the user IDs of people with data permission and the permission lists with data permission that are assigned to them.

SJT refresh processes have to be run regularly to keep security data (in user and transaction SJTs) up to date so that the system enforces data permission using the most current information.

Oracle docs link