Re: Set Role command in SQL*Forms 4.0 or SQL*Menu - Wrong!
Date: Thu, 26 May 94 17:46:40 -0400
Message-ID: <9405261746.PN25814_at_LL.MIT.EDU>
I do not beleive this will work, the role will only be valid within the procedure set_role! Honestly.... Once that procecure call is finished all roles associated with that procedure will disapear.
Correct me if I am wrong or if things have changed since SUN 7.0.12
-jf
>In article <SMUENCH.94May26093529_at_doh.oracle.com> smuench_at_oracle.com (Steven
P. Muench) writes:>From: smuench_at_oracle.com (Steven P. Muench)
>Subject: Re: Set Role command in SQL*Forms 4.0 or SQL*Menu
>Date: Thu, 26 May 1994 16:35:28 GMT
>JAMES -- You do this via stored procedure call:
> Dbms_Session.Set_Role('rolename identified by password');
> ~~~~~~~~~~~~~\~~~~~~~~
> \__ optional
> From Trigger or Procedure.
>--
>Steve Muench Email: smuench_at_oracle.com
>Forms Development CIS: 73404,676
>Product Manager
>Oracle Corporation
Received on Thu May 26 1994 - 23:46:40 CEST