Do you know what are security join tables? Why is it necessary to refresh SJT processes?
Submitted by: AdministratorPeopleSoft 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Peoplesoft Security Job Interview Questions And Answers
Top Peoplesoft Security Questions
☺ | What is SJT_PERSON? |
☺ | What is SJT_CLASS_ALL? |
☺ | Do you know what are the different delivered security sets and how do they function? |
☺ | Can you explain I wish to give access of a page which shows the USA flag to a user but wish to exclude some of the components. How can I do that? Explain the steps? |
☺ | What is SJT_OPR_CLS? |
Top PeopleSoft Categories
☺ | PeopleSoft HRMS Interview Questions. |
☺ | PeopleSoft Financials Interview Questions. |
☺ | Peoplesoft Security Interview Questions. |
☺ | Peoplesoft Tools Interview Questions. |
☺ | PeopleSoft Common Interview Questions. |