• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1302
  • Last Modified:

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.
0
freeka
Asked:
freeka
  • 2
  • 2
4 Solutions
 
actonwangCommented:

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
 
actonwangCommented:
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
 
sathyagiriCommented:
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
 
sathyagiriCommented:
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now