Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle secure views in PL/SQL

48573Feb 16 2006 — edited Feb 17 2006
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2006
Added on Feb 16 2006
3 comments
390 views