Re: FRM-10256
From: Joost Bataille <j.r.l.m.batailleREMOVETHIS_at_uva.nl>
Date: Mon, 15 Jul 2002 16:14:20 +0200
Message-ID: <agulbq$5st$1_at_mail.ic.uva.nl>
Note: The FRM50_ENABLED_ROLES view must exist in the database for menu security to function properly. FRM50_ENABLED_ROLES is automatically created as part of the Form Builder 5.0 table scripts that run during installation if you choose the "Create database tables" option. If you did not choose that option, you or your DBA must logon as SYSTEM and run the SQL script FRM50SEC.SQL (located in the Form Builder SQL directory).
Date: Mon, 15 Jul 2002 16:14:20 +0200
Message-ID: <agulbq$5st$1_at_mail.ic.uva.nl>
Hello Ester,
I found this in Forms 6 online help in 'About implementing menu security'.
Note: The FRM50_ENABLED_ROLES view must exist in the database for menu security to function properly. FRM50_ENABLED_ROLES is automatically created as part of the Form Builder 5.0 table scripts that run during installation if you choose the "Create database tables" option. If you did not choose that option, you or your DBA must logon as SYSTEM and run the SQL script FRM50SEC.SQL (located in the Form Builder SQL directory).
This script must be present on the CD from which you installed Form Builder. Does this help?
Regards, Joost
-- Joost Bataille University of Amsterdam ICT centre www.ic.uva.nl "egg" <egarcia_at_varnet.com> wrote in message news:agm0hj$cl7$1_at_nsnmrro2-gest.nuria.telefonica-data.net...Received on Mon Jul 15 2002 - 16:14:20 CEST
> I'm trying to use menu security,
> first i've Defined some database roles
> after that, i've selected the roles in the "Menu Module Roles" property,
> i've set "Use Security" to yes
> finally, for each menu item, i've set the "Item Roles" property
>
> After that, I've compile the menu module, and execute de form, and I have
> the error:
>
> FRM-10256: You are not enrolled in Form Builder. You do not have SELECT
> permission on the Form Builder base tables.