asked on

Menu Security - Set Up

I was reading "Advanced Forms and Reports", a section about menu security and tried to implement it but I am running into some problems. The following are the steps that I took:

@frm90sec.sql -- Creates the roles
@frm90grt.sql -- Grants roles to user 'USER'
create role CS_INV_POWER_USER
GRANT CS_INV_POWER_USER TO USER

Then I went into forms builder and opened up my menu
- In the property pallette of the menu I set use security to "YES" -- this is for the menu module in general
- Then I added CS_INV_POWER_USER to the MODULE ROLES -- agian the main menu module

Then I went to one of the items in the Menu Module
- Set one item to CS_INV_POWER_USER
- I left the Display Without Privilige set to YES

When I run the form - logged into USER - the menu at the top only has "Window" in it, anyone have any ideas how fix my problem?

sapnam

Yes, first I got the same problem as you did and then could solve it as under (I am on Forms 4.5, maybe the view name has changed).

1. A view FRM45_ENABLED_ROLES is needed for which the create view script is given by ORacle. Please read this provided by Forms Developer Guide

The Oracle Forms menu security feature depends on the view FRM45_ENABLED_ROLES. This view is automatically created as part of the Forms 4.5 table scripts that are run during installation if you choose the "Create database tables" option. If you did not choose that option, you or your DBA must logon as SYSTEM and run the SQL script FRM45SEC.SQL found in the Oracle Forms SQL directory.

Menu modules do not need to be stored in the database. The FRM45_ENABLED_ROLES view is the only object that must exist in the database for menu security to function properly.

2. I set the default role of the user by giving the command

ALTER USER username default role rolename;

3. In the Menu Module properties, I set Menu Security to Yes and put the role name in the Menu Module Roles

4. In the menu items, I have given the Menu Item Roles in the root level menu and the item to which the menu item belongs for the item to be displayed.
So if Masters has 2 choices 1. Dept Master and 2. Employee Master and you need to display Employee Master, then you have to give the Menu Item Roles for both Masters and Employee Master

5. This should get you going

sapnam

While on the topic, let me tell you that this is what Oracle says

The Menu Role property is included for backward compatibility only. Its use is not recommended in current applications.

You can use menu item built-ins like SET_MENU_ITEM_PROPERTY to implement menu security in an elegant manner

Intern

ASKER

sapman>

Thanks for the input - I do have a follow up question though. Regarding your second post, if I want to use the "correct" security implementation then I would do what?

1) In the very first form that is called in the application - Find the user name and the roles associated with that name
2) use the roles to disable or enable items on the menu
- using a procedure in the form to get the role and hide items?

I am not sure exactly how to implement this - it seems like the old way of using the default menu security is easier to do, and cleaner. Anyway if you could give me your thoughts on how you would do this if you were using forms 9 I would greatly appreciate it.

ASKER CERTIFIED SOLUTION

sapnam

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial