Re: applying Oracle application security to custom tables

I know of a few ways of doing this. If you want to do this using a view and need it to be updateable, you need to make sure you define the view as a way so that all of the joins are as follows;

SELECT employee FROM employees WHERE region IN (SELECT region FROM security WHERE USERNAME = USER) with check option;

Where table2 is your security table which has the relationship between employees and what regions they can see. The PL/SQL would basically do the same filering as the view in generating your output.

Hope this helps

Craig

KR <rmakanji_at_mindspring.com> wrote in article <741qt9$bt5$1_at_camel15.mindspring.com>...
> Hi
>
> I need to apply the same security that Oracle uses to restrict access to
its
> HR data. For example, a south east manager should only be able to see
> employee records in his region.
>
> I believe it uses the security profiles in some way but not sure if it
is
> on the application level or can it be done through views and PL/SQL.
>
> I would appreciate any suggestions
>
>
>
Received on Mon Dec 14 1998 - 14:10:51 CST