Interview Questions.

Q1. When A User Is Tied To A Primary Permission List How Does It Decide The Department Data Access For The Employee? Where And How Is This Mapping Done?

User is tied to a number one permission list in consumer profile desk. This permission listing is tied to a setid and deptid in the safety setup. This can be performed with the aid of navigating to Setup HRMS -> Security -> Core row degree security -> Security by way of dept tree. All the departments that get tied here towards the permission listing are accessible to the consumer.

Q2. How Is Security By Department Tree Different Than Security Access Types?

Security through department tree defines which setid and deptid a permission listing has get admission to to. Security get admission to types are unique methods wherein security may be driven for a protection set. For instance branch safety can be driven with the aid of branch tree or branch setid. Both those are security get right of entry to kinds which belong to safety set branch.

Q3. Describe The Flow Of Setting Up Application Security. When A New Functionality Is Released How Do We Setup A User In Ps To Get Access To It?

When a brand new capability wishes to be supplied get entry to for users, then roles and permissions are used. The capability is related to a menu—component—web page. So the user desires to get get entry to to the web page in one of the diverse modes like: Add, update or view only. For this, the menu – component – page layer is tied to a permission listing. This permission list is then attached to a function and the person is then furnished this role thru consumer profile. As a result user will be capable of get right of entry to the capability.

Q4. What Are Security Join Tables? Why Is It Necessary To Refresh Sjt Processes?

PeopleSoft system shops safety information in user and traction Security Join Tables. (SJTs).

User SJTs are:

SJT_OPR_CLS: Contains the User IDs with their records permission lists.

SJT_CLASS_ALL: Contains the information permission information for all of the records permission lists that are given information get right of entry to on the ‘Security via Dept Tree’ page or ‘Security with the aid of Permission List’ page.

Traction SJTs are:

SJT_PERSON: Contains traction records for the people (employees, contingent employees, Person of Interest). It has row degree protection attributes (SetID, DeptID and so on) for all of the employees.

SJT refresh tactics should be run to keep protection records (in user and traction SJTs) up to date in order that the machine enforces data permission the usage of the maximum contemporary records.

Q5. If An Organization Does Not Fit To Be Position Driven Then What Are The Other Options In People Soft To Setup The Hierarchy?

If the organisation isn't always healthy to be function pushed, then the other alternatives to be had are:

By Person: In this technique, job codes are used to classify activity information into corporations. Job codes have one to many relationships with employees, i.E. More than one personnel may have the equal job code. Jobs to be executed are recognized inside the company. Job codes can be shared throughout departments, places or agencies.

Partial Position: There is probably a scenario in which the system must be driven by way of both the tactics – by means of man or woman and by position. In this situation, partial function control can be carried out. Driving by role may paintings for sure departments or executive ranges whereas others can be man or woman pushed.

Q6. What Is Sjt_opr_cls?

SJT_OPR_CLS: Contains the User IDs with their records permission lists.

Q7. Explain The Flow Of Setting Up Application Security. When A New Functionality Is Released How Do We Setup A User In Ps To Get Access To It?

When a new capability needs to be provided get admission to for customers, then roles and permissions are used. The functionality is related to a menu—element—page. So the user wishes to get get right of entry to to the page in one of the various modes like: Add, replace or view best. For this, the menu – thing – page layer is tied to a permission listing. This permission listing is then connected to a function and the consumer is then furnished this position through user profile. As a end result consumer can be capable of access the capability.

Q8. Suppose Organization Xyz Uses Ps Department Security. There Are four Levels In The Department Tree 1,2,3 And four With four Being At The Top Of The Tree. If A Manager A Is In Dept three And Has 2 Direct Reports In

If the direct reviews also are in branch three then they can see the statistics for personnel in branch 2 and 1 best. They can't see the statistics for a populace that's above their branch tree node. Since four is above three they can not see the facts.

 

Q9. Suppose When A User Is Tied To A Primary Permission List How Does It Decide The Department Data Access For The Employee? Where And How Is This Mapping Done?

User is tied to a primary permission list in consumer profile table. This permission listing is tied to a setid and deptid in the security setup. This may be completed by means of navigating to Setup HRMS -> Security -> Core row level protection -> Security by way of dept tree. All the departments that get tied here towards the permission list are on hand to the user.

Q10. 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?

Any person whose Primary Permission List is set up to reveal a particular u . S . Will display its flag as properly. The navigation for the same is: Setup HRMS -> Security -> Component and Page Security -> Setup Global Security. If america flag must be shown to the person, USA must be decided on in the united states activate. There is a hyperlink to ‘Excluded Components’ in the panel, which may be used to exclude sure additives.

Q11. 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?

Any consumer whose Primary Permission List is set up to expose a particular united states will display its flag as well. The navigation for the identical is: Setup HRMS -> Security -> Component and Page Security -> Setup Global Security. If america flag needs to be proven to the user, USA have to be decided on inside the us of a set off. There is a hyperlink to ‘Excluded Components’ within the panel, which may be used to exclude certain components.

Q12. Suppose Organization Abc Uses Department Security With Dept 1 As The Parent Department. Dept 2 Is The Child Of Dept 1, Dept three And Dept four Are The Child Of Dept

Since Dept 1 is the determine branch and study/write get admission to is given for Dept 1, the person may have get entry to to all of the departments below Dept 1, i.E. Dept 2, Dept three and Dept 4.

Yes, we can limit the access to Dept three with the aid of giving ‘No Access’ to Dept 3 at the same time as defining the get entry to code for Dept three at the Security be Dept Tree page of the respective permission list.

Q13. How Is Field Level Security Controlled In Peoplesoft?

There isn't any delivered protection for area stage, i.E. No configurable manipulate exists for subject-degree access for a user. If there may be a demand of discipline level safety, then it has to be finished at the extent of PeopleCode, i.E. Programmatically.

Q14. What Is Row Level Security? What Are The Different Ways To Design Row Level Security?

Row degree protection is also referred to as Data Permission Security. It determines the get entry to given to a user for all/unique set of rows thru any PeopleSoft aspect which may be introduced or custom. For a row, get entry to to all of the fields is given.

Row degree security restricts consumer’s get admission to to a subset of rows primarily based at the price inside a subject inside the record. That field will be department, task place, process enterprise, task profits grade and so on. There are positive PeopleSoft added safety sets and access types which can be used as a basis of restriction. For e.G., restrict access for a user (the use of Job statistics aspect) to all the personnel having a cost of ‘SALES’ for the branch area in the current powerful dated job row.

Q15. Suppose If A Person Is Assigned Row Security For A Department, Will He Have Access To All The Child Departments As Well? If Yes, Is There A Way We Can Restrict Access To One Of Those?

By default, the consumer will have access to personnel of all of the baby departments. Although, get right of entry to to employees in a baby department may be confined through information permission list. To define the security profile of a branch tree, navigate to: Setup HRMS -> Security -> Core Row Level Security -> Security by Dept Tree. For the precise row security permission list, get admission to codes can be set to ‘No Access’ for a child department to limit access.

Q16. What Is Sjt_class_all?

SJT_CLASS_ALL: Contains the records permission information for all the records permission lists which are given information get admission to at the ‘Security by Dept Tree’ page or ‘Security via Permission List’ web page.

Q17. If I Am Able To See The Brazil Flag In A Component By Me Of Global Security, Will I Be Able To See Brazil Employees Too?

No, you'll not be capable of see Brazil personnel. Global Security presents you the permission to look a specific flag and no longer the data. Access to employees is given by means of me of Row degree Security.

Q18. Do You Know How Is Security By Department Tree Different Than Security Access Types?

Security by using department tree defines which setid and deptid a permission list has get right of entry to to. Security get admission to kinds are exclusive ways wherein security may be driven for a protection set. For instance department safety can be pushed by means of department tree or branch setid. Both those are safety get right of entry to kinds which belong to safety set department.

Q19. What Are The Different Delivered Security Sets And How Do They Function?

The exceptional protection sets are: - Department, People with jobs, People with out jobs, US federal human beings with jobs, Recruiting process openings and template based lease.

For every security set, admin can allow or disable the get entry to kind. Based on this setup, the system will determine the kind of security. For instance, branch safety could be pushed based on branch tree, that's one access kind or it is able to be pushed via branch setid that is another get entry to type for the safety set branch.

For POIs without a job rows, to define security, the safety set People with out jobs is used. The other options are get entry to sorts like vicinity, commercial enterprise unit or institution. So, the one which is enabled, will power the safety.

Q20. What Is Sjt_person?

SJT_PERSON: Contains traction statistics for the human beings (employees, contingent employees, Person of Interest). It has row level protection attributes (SetID, DeptID and so on) for all of the employees.