-
I am trying to create a custom security profile in Oracle HRMS. So I went to the 'Security Profiles' screen -> Custom Security tab, check the 'custom restriction' check box and begin typing my SQL where clause. Here is my question:I type this:ASSIGNMENT.grade_id not in ( select grade_id from per_grades where PER_GRADES.NAME not like 'G%' or PER_GRADES.NAME not like 'M%') and it all works fine.However, if I type per_all_assignments_f instead of ASSIGNMENT, I get ORA - 00904 error. Why does this happen? How will I know what alias to use in case I want to include a different table in the query?
-
-
I have defined a security rule and assigned it to my responsibilty, but is still does not work, why?
Make sure that you have enabled security at both the segemnt and value set levels, it must be enabled at both these levels to work. Also make sure you have switched out and back into the responsibility.
Ans