-
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
-
NO
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
If There Is somthing to do it just do it with oracle ....
-
same message again
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
-
Re: same message again
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;
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
It works fine, thanks a lot
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|