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

Thread: Run menu Builder

  1. #1
    Join Date
    Jul 2001
    Location
    ksa
    Posts
    37

    Question

    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
    If There Is somthing to do it just do it with oracle ....

  2. #2
    Join Date
    Aug 2001
    Posts
    20
    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.

  3. #3
    Join Date
    Jul 2001
    Location
    ksa
    Posts
    37

    Exclamation 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
    If There Is somthing to do it just do it with oracle ....

  4. #4
    Join Date
    Jul 2001
    Location
    ksa
    Posts
    37

    Unhappy 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.
    If There Is somthing to do it just do it with oracle ....

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