| frm 10247 [message #126638] |
Wed, 06 July 2005 01:21  |
harmeet.gambhir
Messages: 30
Registered: June 2005
|
Member |
|
|
hi everybody..
i have a customized menu module in which i want to disable certain menus for certain users.
i ran the following script (in the sys schema) in the file frm90sec.sql
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;
apart from this created a role menu_admin in sys and granted it to user purchase.
then in the menu file main.mmb, i enabled the use Security to yes, selected menu_admin as the item_role.
then in the sub_menu (create_indent), i selected the item role(menu_admin), but when i run the form i get the frm-10247 error no active items in root menu of application..
pl. help
thanks in advance..
harmeet
|
|
|
|
|
|
| Re: frm 10247 [message #168527 is a reply to message #126638] |
Thu, 20 April 2006 20:07  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
You have turned security 'on', did you give 'purchase' access to the root menu?
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
