Error creatting menu

Hi,

I have created form with Forms 6.0 and assign that form own menu.

When I run this form I get the message
frm-10256 User is not authorized to run Form Bulider Menu.

In help there is explanation that I do not have SELECT permission on the Form Bulider tables.

Thanks

Hi gkaracic,

Check if your menu module has Use Security Property set to YES.

skid

Menu module Use Security Property set to No and I get the same message

Hi all

1-create this view under system account

create or replace view FRM50_ENABLED_ROLES
as select urp.granted_role role,sum(distinct decode(rrp.granted_role,
'ORAFORMS$OSC',2,'ORAFORMS$BGM',4,'ORAFORMS$DBG',1,0)) flag
from sys.user_role_privs urp, role_role_privs rrp
where urp.granted_role = rrp.role (+)
and urp.granted_role not like 'ORAFORMS$%'
group by urp.granted_role

-------------------------------------------

2-to enable user to run menu grant select on the FRM50_ENABLED_ROLES like this

grant select on FRM50_ENABLED_ROLES to scott;

now scott can run the menu please try this and tell me...
Regards
mohammed

Hi mohammed
I am running my form in Forms 6.0 so I created view
FRM60_ENABLED_ROLES and FRM50_ENABLED_ROLES too, and granted SELECT on this view to user1.
I get the same message again.

Thanks

Quote:

---

Originally posted by gkaracic
I get the same message again.

Thanks

---

Have you run frm60sec.sql? If no, then run it. Then as SYSTEM run

Code:

---

GRANT SELECT on FRM50_ENABLED_ROLES to PUBLIC;

---

It works fine, thanks a lot