DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Error creatting menu

  1. #1
    Join Date
    Nov 2001
    Location
    BIH
    Posts
    6
    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

  2. #2
    Join Date
    Apr 2002
    Location
    Philippines
    Posts
    77
    Hi gkaracic,

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

    skid

  3. #3
    Join Date
    Nov 2001
    Location
    BIH
    Posts
    6

    NO



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


  4. #4
    Join Date
    Jul 2001
    Location
    ksa
    Posts
    37
    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 ....

  5. #5
    Join Date
    Nov 2001
    Location
    BIH
    Posts
    6

    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

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    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

  7. #7
    Join Date
    Nov 2001
    Location
    BIH
    Posts
    6
    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
  •  


Click Here to Expand Forum to Full Width