Re: PL/SQL testing for assigned roles

Mike West wrote:
>
> I am writing an application using paradox as the front end to an oracle
> database. I want to be be able to test to see what role a user has
> assigned to them and use this to determine what menus etc to give the
> user access to.
> Is there an easy way in PL/SQL to test to see if a user belongs to a
> certain role??? I have tried using the user_role_privs table but the
> problem with this method is that when the procedure is called it gives
> the user_role_privs info for the owner of the procedure and not the
> current user.

Try using SESSION_ROLES.

Bob Morrison Received on Tue Jan 07 1997 - 00:00:00 CET