Re: Using Oracle Roles?

Douglas Scott wrote:
>
> Can anyone point me to a third party product or information on using
> Oracle roles within an application? What I would like to do which I
> heard is possible is to set up roles with database privileges so that
> when a user runs a particular application they will have all the
> necessary table privileges needed by the application and when they exit
> the application all the privileges go away.
> --
>
> Douglas Scott
> Douglas.S.Scott_at_boeing.com

Douglas,

We've had a similar requirement. Further to what Thomas Vanya I would also point at the stored package DBMS_SESSION.Set_Role. (I am assuming we are talking Forms 4.5 here) This can be set (after a connection has been made) to allow the neccessary priviledges. What we have done is to programmatically set a logon role that only has access to tables that can verify the user and password etc . Once that has been verified then the same function can be used to set the role for access to the application tables proper.

Hope this is of some help.

Regards,

John G. Williamson
Aberdeen
Scotland. Received on Thu Oct 09 1997 - 00:00:00 CDT