How to combine two person security profile in one data role
Summary:
We have a requirement wherein a user can either have a Legal Employer AoR or Department Hierarchy AoR assigned to him or both. The Oracle standard delivered functionality is that these are two separate security profiles. Hence, we created a custom SQL criteria to satisfy the requirement. However, the SQL criteria that we have created is either resulting in a wrong output or is encountering a performance issue (long running). Is it possible to combine 2 security profiles in Oracle? will it work? Below is the SQL criteria that we have created.
(EXISTS(SELECT 1
FROM PER_ALL_ASSIGNMENTS_M ASG,