Re: PL/SQL testing for assigned roles
Date: 1997/01/10
Message-ID: <32D697DE.732D_at_TEK.COM>#1/1
Mike:
I know of a developer here who has done just that. The technique is based on having select access to the dba_role_privs table, and querying it based on a database username. You will have to have that username to make it work.
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.
Jerry Kohler
Tektronix Inc. Database Administration
The views expressed in this post are my own and not necessarily those of Tektronix Inc. Received on Fri Jan 10 1997 - 00:00:00 CET