| |
GeekInterview.com > Interview Questions > Oracle Apps > Segment Security
| Print | |
Question: 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?
|
| July 07, 2008 12:51:07 |
#1 |
| sabini |
Member Since: July 2008 Total Comments: 1 |
RE: 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:ASSIGNME
|
| Please check your table alias name |
| |
Back To Question | |
