I create menu and compile it ,I type the menu name
on the form but if I run the form I Receive this error
frm-10256 user not autherized to run form builder menu
how I can grant run form builder menu to user please
can any one help me .
You have to run the following script to enable the forms menu
create or replace view FRM50_ENABLED_ROLES as
select urp.granted_role role,
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;
create public synonym FRM50_ENABLED_ROLES for system.FRM50_ENABLED_ROLES;
create role ORAFORMS$OSC;
create role ORAFORMS$DBG;
create role ORAFORMS$BGM;
run the above script logged in as SYS .and grant select on the
synonym to the respective users.
Thanks for your help I run the script but I dont Know what the Benefits of this script on my subject (run form builder) can you Explain what the script do please .... I grant select on synonym to user I select from the synonym the select statement return Description for all roles that created by user I don't understand what that's mean please check and tell me ..Ok
Run Menu builder
Can any one help me I can't run form menu builder if I Apply
the Security on my menu I cant run the form menu builder
and I Receive the error
FRM-10256 (user is not autherized to run form menu builder)
that is very important for me Ok.