Re: form builder 6.0 : problem with attaching a menu to a form (FRM-10256)

From: Suresh Bhat <oracleguru_at_lycos.com>
Date: 14 Jul 2004 07:58:09 -0700
Message-ID: <9c64199c.0407140658.52099806_at_posting.google.com>

Here are my notes from March 2000 when I converted Forms 3.5 to Oracle Forms 6.
Things may be different now than in 2000, so take this as an example to go by.

---

Use of Menu Role property for the Form is not recommended. It is for backward compatibility.

There are 2 ways to enforce Menu security. The easier way, which we are using at this Company is given below as the first method. In either case you create the database Roles in the server database instance.

Method 1:

DBA userid is ops$dba. Developer/User is ops$sbhat.

Create menu roles such as abc_menu, template_menu, xyz_menu under ops$dba and then grant apropriate menu role to the user.

   grant template_menu to ops$sbhat;

In the 1st method you enable or disable the menu item depending on the session_role of the user. A common function, CHECK_MENU_ROLE checks if the user has the appropriate role and will return TRUE if the database role has been assigned to that user. The following is an example:

if check_menu_role('TEMPLATE_MENU') then /* This will gray out the menu item named template_form */

                                   set_menu_role(&#61502;template_menu.template_form&#61501;, enabled, property_false);
/* This will hide the menu item named template_form entirely */

                                   set_menu_role(&#61502;template_menu.template_form&#61501;, visible, property_false);
else
null;
end if;

Method 2:  

If you want to use the second method then you also need to create the view, FRM50_ENABLED_ROLES under Oracle user SYATEM. The script to create this view is frm60sec.sql or frm60bld.sql in the folder \oracle6i\orant\tools\dbtab60\forms60. This view can be created by copying and directly running the SQL script on the server. After it is created, give the SELECT privilege to role PUBLIC so that all Oracle users have access to it.

In the Menu module property palette, set

Use Security  	Yes
Module Roles	Double click and enter all Roles that are to be used in

this module.

In the Menu Item property palette, set
Item Roles Double click and enter appropriate roles to display this Menu item.
Display without Privilege For users that do not have the appropriate roles

No 	Menu Item will be hidden completely.
Yes	Grayed out but visible

At least one Menu Item must have a role.

HTH Suresh Bhat

sstolpe_at_gmx.de (S. Stolpe) wrote in message news:<7f722c77.0407132321.7b580e41_at_posting.google.com>...
> Smiley <Anoniemke888getridofthis_at_hotmail.com> wrote in message news:<40f3fc3c$0$764$3a628fcd_at_reader10.nntp.hccnet.nl>...
> > S. Stolpe wrote:
> > > Hi,
> > >
> > > I've got the following problem :
> > > I created a Form with form builder 6.05 and a menu with the menu
> > > editor. The menu compiled without error and was saved as .mmx in the
> > > correct directory.
> > > I changed all the respective entries in the forms-properties and
> > > started the form.
> > >
> > > When I run the form the error-message :
> > > FRM-10256 : USER HAS NO PRIVILEGE TO EXECUTE FORM BUILDER MENU.
> > >
> > > turns up and the form runs without any menu.
> > >
> > > our dba is at a loss, finding no dictionary tables whatsoever
> > > connected to form builder menu.
> > >
> > > has anyone got a clue where to look for the missing privilege ?
> > >
> > > Thanks a lot,
> > > Susanne Stolpe
> >
> > Cause: You are not enrolled in Form Builder. You do not have SELECT
> > permission on the Form Builder base tables.
> >
> > Action: Notify your DBA.
> >
> >
> > Hth,
> >
> > :)
>
> Hi,
> our DBA knows about it.
> strange enough, we've a form running (not developed by ourselves)
> which has got an individual menu without using any form builder base
> tables. (At least we don't have any form builder base tables in that
> database, and we needn't to get enrolled anywhere).
> Is there another way to create a menu for a developer application
> without using the menu editor ?
>
> Thanks again,
> Susanne Stolpe
Received on Wed Jul 14 2004 - 16:58:09 CEST