Hi
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 .
thanks
mohammed shake
08-01-2001, 04:29 AM
kshailesh
Hi
You have to run the following script to enable the forms menu
security features
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;
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.
regards
Shailesh .k.
08-02-2001, 02:26 AM
mohammed
Menu Builder
Hi kshailesh
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
Thanks
Mohammed Al-shake
08-02-2001, 12:14 PM
mohammed
Run Menu builder
Hi
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.