Re: Oracle Forms 6 Question - Dynamic Menus?

Hi George,

We had a similar requirement and use role-based security. Immediately after login we read the system standard user_role_privs table to determine the user's access level and set their roles accordingly. All menu items are associated with one or more database roles, and the user only sees those items they have access to.
We use a reference screen to maintain the users and their application access level. During commit processing the screen calls a stored procedure that issues dynamic sql to grant and revoke roles, eg. EXECUTE IMMEDIATE 'REVOKE ' || your_role || ' FROM ' || your_username;

George E. Gifford wrote in message <3B45F85A.83808F5D_at_dfrc.nasa.gov>...
>Recently started working in Oracle Forms 6 with Oracle 8i database.
>
>I would like to create either a dynamic menu or selection list, based
>upon the user login name (maintained in a table), which will present the
>user with only the choices he/she is able to access. The form names
>called and access levels are also maintained within tables we have set
>up for this purpose.
>
>Currently I have been able to implement what I want using a view of the
>various tables needed along with a LOV; however, there is very little
>that I can do to customize the Look of the LOV.
>
>Is is possible to create a menu "on-the-fly" as is possible in either
>Delphi, VB, etc.??
>
>Or, if possible, how would one go about creating a selection list for
>this purpose using a view or table?
>
>Any ideas or suggestions would be greatly appreciated. I have over 10
>years experience with Oracle, PL-SQL, and numerous development
>platforms; however, just recently started working with Oracle Forms.
>Somewhat different than what I am used to.
>
>Again.... any help or suggestions would be appreciated.
>
>Thanks!
>
Received on Tue Jul 24 2001 - 06:40:18 CEST