Custom Security in Security Profiles in Oracle HRMS

5) Custom Security

Options available in this region are

• Restrict the people visible to this profile

• Restrict the people visible to each user using this profile

Enter a valid SQL WHERE clause fragment to select a group of records. For example, to add a restriction that assignments must have a grade starting with S e.g. Staff, and employee number should start with F, considering employee number conventions as e.g FFL-00001, PFL-00001. add the following SQL fragment:

ASSIGNMENT.GRADE_ID IN

(SELECT GRADE_ID FROM  PER_GRADES PG

WHERE  PG.NAME LIKE 'S%')

AND ASSIGNMENT.ASSIGNMENT_NUMBER IN

(

SELECT ASSIGNMENT_NUMBER FROM PER_ASSIGNMENTS_F

WHERE ASSIGNMENT_NUMBER LIKE 'F%')

Note: In addition, the View Employees or View Contingent Workers option is set to Restricted, and the "Restrict the people visible to each using this profile" option is set on the Custom Security tab.

After having created the profile and assigned it to the user, you need to run "Security List Maintenance" concurrent program for changes to take effect. Check

How to assign Security profile to a user

How to run Security List Maintenance Concurrent Program

For further details, please visit

Security rules docs in Oracle