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

John Alexander wrote:

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

Not quite - by default all menu items will be displayed, but the one you are not authorized for are greyed out.

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

--
Gtrz,

Frank van Bortel