How to assign row level security to users?
Submitted by: AdministratorThe steps to assign row level security are:
i) Assign desired values of fields (department/ job location/ job company/ business unit etc) to Data Permission Lists
ii) Assign these Data Permission Lists to users
If field is ‘Department':
i) Data Permission List is given access to values values of ‘Department' field defined at various levels in Department Security Tree through: Set Up HRMS -> Security -> Core Row Level Security -> Security by Dept Tree
ii) Users are directly assigned to Data Permission List in user Profiles component – ‘General' page – Row Security field. A user can be assigned to only one Data Permission List at a time.
If field is not ‘Department' but ‘Location', ‘Business Unit', ‘Salary Grade' etc:
i) Data Permission Lists are given access to values of these fields through: Set Up HRMS -> Security -> Core Row Level Security -> Security by Permission List
ii) Users are assigned to Data Permission Lists through roles in user profiles component (Roles page). Multiple such roles can be assigned to users as per requirement.
OR
Users are directly assigned to Data Permission Lists in user profiles component – General page – Row Security field.
Submitted by: Administrator
i) Assign desired values of fields (department/ job location/ job company/ business unit etc) to Data Permission Lists
ii) Assign these Data Permission Lists to users
If field is ‘Department':
i) Data Permission List is given access to values values of ‘Department' field defined at various levels in Department Security Tree through: Set Up HRMS -> Security -> Core Row Level Security -> Security by Dept Tree
ii) Users are directly assigned to Data Permission List in user Profiles component – ‘General' page – Row Security field. A user can be assigned to only one Data Permission List at a time.
If field is not ‘Department' but ‘Location', ‘Business Unit', ‘Salary Grade' etc:
i) Data Permission Lists are given access to values of these fields through: Set Up HRMS -> Security -> Core Row Level Security -> Security by Permission List
ii) Users are assigned to Data Permission Lists through roles in user profiles component (Roles page). Multiple such roles can be assigned to users as per requirement.
OR
Users are directly assigned to Data Permission Lists in user profiles component – General page – Row Security field.
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. |