Oracle secure views in PL/SQL
48573Feb 16 2006 — edited Feb 17 2006Hi,
I'm running an Oracle Report through the Concurrent Manager.
I have a parameter that's tied to a value set. It's a simple
query to pick all orgs within the current Responsibility's security profile (select * from hr_organization_units).
The user can select an org, or leave the parameter blank to select all orgs within the security profile. I've confirmed that
the list is showing the correct orgs.
The Oracle Report is tied to an external PL/SQL package (returns type Ref Cursor).
Basically, if we perform "select * from hr_organization_units" in the PL/SQL, we get a different result - ALL orgs are picked,
regardless of the security profile.
I've concluded that the HR_SECURITY.SHOW_RECORD function isn't working because somehow, the responsibility_id isn't being automatically passed to the external PL/SQL.
Any thoughts? This seems like a very basic concern; it would
be hard to believe that custom code would be needed.
Thanks for any help