Error creatting menu

[gkaracic]

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

[skid]

Hi gkaracic,

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

skid

[gkaracic]

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

[mohammed]

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

[gkaracic]

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

[julian]

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

GRANT SELECT on FRM50_ENABLED_ROLES to PUBLIC;

[gkaracic]

It works fine, thanks a lot