Menu Security - Set Up
Posted on 2004-09-03
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?