Home » RDBMS Server » Security » Oracle secure views in PL/SQL
Oracle secure views in PL/SQL [message #159206] Thu, 16 February 2006 14:16
Messages: 17
Registered: April 2005
Junior Member

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,

Previous Topic: Restricted User Role
Next Topic: Creating new user?
Goto Forum:

Current Time: Tue May 24 10:18:53 CDT 2022