Newsgroups: comp.databases.oracle
From: mla@132.203.6.11  (Michel Lalonde)
Subject: Re: Set Role command in SQL*Forms 4.0 or SQL*Menu
Message-ID: <19940606165450.mla@132.203.6.11>
Lines: 23
Sender: news@athena.ulaval.ca
Nntp-Posting-Host: 132.203.150.57
Organization: U. L.
X-Newsreader: FTPNuz (DOS) v1.0
References: <9405251704.PN10996@LL.MIT.EDU> 
Date: Mon, 6 Jun 1994 20:54:00 GMT


In Article <9405251704.PN10996@LL.MIT.EDU> "forgy@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@CTI.ULAVAL.CA
Universite Laval
Ste-Foy, Quebec, Canada
G1K 7P4
-----------------------------------------------------------