Re: Form 6: How to use menu item tole in application?

[Quoted] [Quoted] Oracle roles can be set to default, so that they are enabled immediately when the user logs in. Roles can also be set so that they do not default. Instead they have to be specifically enabled for that session after the user logs in. So the scenario would be:
[Quoted] [Quoted] 1) Your user logs in to Oracle, with no special roles enabled. [Quoted] 2) Then he logs in to your application, you look at your application tables [Quoted] and decide which roles that user should get, and enable those roles (you can [Quoted] enable roles using the dbms_session package)

[Quoted] [Quoted] I haven't tried it, but am guessing that, as long as you enable the roles before opening the form that contains your menu, Forms will recognize those [Quoted] session roles and that the available menu items would display accordingly.

[Quoted] [Quoted] Peter Yu <yuyh_at_sp.edu.sg> wrote in message news:3a091c17.0_at_scctn03.sp.edu.sg...
> The menu in Form 6 has the feature of tailoring the menu according to the
> user. This is done be setting the role for each menu item and turning the
> menu module's "use security" property on. The menu was available to the
> end-user would depend on the database privilege of the end user.
>
> This is possible if each end users uses a different database account. If
> the application uses an application account and the end-user's account
> become part of the application data, how can the above feature of menu be
> used ?
>
> Please help or comment.
>
>
>
Received on Wed Nov 08 2000 - 12:53:44 CET