Tell me what is row level security? What are the different ways to design row level security?
Submitted by: AdministratorRow level security is also known as Data Permission Security. It determines the access given to a user for all/specific set of rows through any PeopleSoft component which can be delivered or custom. For a row, access to all the fields is given.
Row level security restricts user's access to a subset of rows based on the value within a field in the record. That field could be department, job location, job company, job salary grade etc. There are certain PeopleSoft delivered security sets and access types which can be used as a basis of restriction. For e.g., restrict access for a user (using Job data component) to all the employees having a value of ‘SALES' for the department field in the current effective dated job row.
Submitted by: Administrator
Row level security restricts user's access to a subset of rows based on the value within a field in the record. That field could be department, job location, job company, job salary grade etc. There are certain PeopleSoft delivered security sets and access types which can be used as a basis of restriction. For e.g., restrict access for a user (using Job data component) to all the employees having a value of ‘SALES' for the department field in the current effective dated job row.
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. |