Do I need to run a script in Oracle 10g to use DB roles in conjunction with Oracle 10g Forms/Menu

Hi there

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.



Please advise.
freekaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
sathyagiriConnect With a Mentor Commented:
There should be a sql file something like frm60bld.sql under the forms10G folder, running that would create all your base tables and then running the frm60sec.sql should grant you all the permissions
0
 
actonwangConnect With a Mentor Commented:

There should be a script in the admin directory called FRM60SEC.SQL. This creates a view that is required for menu security to work. It also grant the privileges to view it.



0
 
actonwangConnect With a Mentor Commented:
RM-10256: User is not authorized to run Form Builder Menu.

Cause: You are not enrolled in Form Builder. You do not have SELECT permission on the Form Builder base tables.

Action: Notify your DBA.
0
 
sathyagiriConnect With a Mentor Commented:
The script needs to be run by system user.
0
 
freekaAuthor Commented:
What are the Form Builder base tables and how do I install them ?

I am also the DBA ;-)

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.