Re: determining users access levels

user_role_privs contains the roles that are held by the current user. There are columns within this table to determine if the user has administrative control of the role, if it is a default role, etc.

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 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???

Frank Thomas
thomasf_at_daugherty.com Received on Tue Dec 17 1996 - 00:00:00 CET