Do I need to run a script in Oracle 10g to use DB roles in conjunction with Oracle 10g Forms/Menu
Posted on 2006-07-10
I have successfully run a form in Oracle 10g Forms with a menu attached.
The menu has the property 'Use Security' set to No which allows it to be displayed.
If this is set to yes, then I get the error:
"FRM-10256 : User is not authorized to run Form Builder Menu."
The roles are defined in the properties of the menu and are attached to the various menu's and sub-menu's in the mmb file.
The roles are also created in the database and assigned to the user that is running the form.
I'm sure I'm missing a script to do with base tables or something but problem is that all the info I find is for an older version of Oracle technology.