Re: Set Role command in SQL*Forms 4.0 or SQL*Menu

In Article <9405251704.PN10996_at_LL.MIT.EDU> "forgy_at_ll.mit.edu (James Forgy)" says:
>
> Question:
>
> I have tried using the "set role [rolename] identified by..." in a form,
> it doesn't work using either triggers or procedures. Does the Set Role
> command work in SQL*Menu and/or does it work in Forms 4.0?
>

In FORMS 4.0.13 there is a built-in named FORMS_DDL that can execute any DDL including SET ROLE. It is documented in the release notes. You can call this built-in from the WHEN_NEW_FORM_INSTANCE trigger to control access to the for

Michel Lalonde                  Tel: (418) 656-3632
Centre de Traitement            Fax: (418) 656-7305
    de l'Information       Internet: MLALONDE_at_CTI.ULAVAL.CA