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

[Quoted] I thought that regardless of whether the role was enabled or not, the menu choices would still appear? Forms uses a view that makes use of roles to determine whether the menu items are visible or not and I didn't think it took into account whether the role was actually enabled. (I think it looked [Quoted] at user_role_privs vs session_roles).

Anyway, even with that in mind, you can still programmatically navigate through all menu choices and enable/disable the menu items based on currently active roles. And then issue a replace_menu call after the new menu has been "rebuilt".

"John Alexander" <jalexander_at_summitsoftwaredesign.com> wrote in message news:c9bO5.18344$vc3.2339006_at_typhoon.tampabay.rr.com...
> 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:
> 1) Your user logs in to Oracle, with no special roles enabled.
> 2) Then he logs in to your application, you look at your application
 tables
> and decide which roles that user should get, and enable those roles (you
 can
> enable roles using the dbms_session package)
>
> 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
> session roles and that the available menu items would display accordingly.
>
> 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 Sun Nov 12 2000 - 22:00:02 CET