Re: PL/SQL testing for assigned roles
Date: 1997/01/07
Message-ID: <5atnc8$9au_at_boursy.news.erols.com>#1/1
I'd be interested to know this also. I looked and the only thing I could find was dba_role_privs. Fortunately I when I asked for a select priv on this table the powers that be said ok.
Mike West <mwest_at_hort.cri.nz> 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.
Scott Mattes
smattes_at_erols.com
"Our laws and our institutions must necessarily be based upon and embody the teachings of the Redeemer of mankind. It is impossible that it should be otherwise; and in this sense and to this extent our civilization and our institutions are emphatically Christian." - United States Supreme Court, 1892.
Don't support forced abortions -- boycott 'made in China'!
Check out the U. S. Taxpayers' Party at www.ustaxpayers.org
Watch your government employees at http://www.vote-smart.org Received on Tue Jan 07 1997 - 00:00:00 CET