Home -> Usenet -> comp.databases.oracle -> Re: Set Role command in SQL*Forms 4.0 or SQL*Menu

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

From: Dave Mausner <dmausner_at_brauntech>
Date: Thu, 26 May 1994 19:43:09 GMT
Message-ID: <1994May26.194309.2836_at_nntpxfer.psi.com> 







In article <9405251704.PN10996_at_LL.MIT.EDU>, forgy_at_ll.mit.edu (James Forgy) says:


>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?




investigate using the package function "dbms_session.set_role(rolename)"
which assumes that you have the procedural option installed.  this package
is an optional install item.



Dave Mausner, Sr Consultant, Braun Technology Group, Chicago.
Received on Thu May 26 1994 - 21:43:09 CEST












Original text of this message