Re: SET ROLE in PL/SQL

From: raymond allo <raymond_at_ramavista.com>
Date: 1997/12/12
Message-ID: <34907138.713C@ramavista.com>#1/1

Jerry Apfelbaum wrote:
>
> We have not had any success with trying to execute the SQL command:
> SET ROLE ThisRole IDENTIFIED BY ThisPassword;
> using dynamic SQL in either an anonymous PL/SQL block or in a stored
> procedure.
>
> Can this be done? If not, is there an explanation as to why this is not
> permitted?
>
> --
> =====================================================================
> Jerry Apfelbaum
> Eastern Sun Group Inc.
> Toronto, Canada
> ---------------------------------------------------------------------
> (Due to proliferation of spammers, remove 'nospam' my email address.)
Jerry,

I had the same problem and contacted Oracle about it. It doesn't work unfortunately. i have put in a change/enhancement request though. But for the mean time it is a no brainer.

Raymond Allo
Ramavista Pty Ltd
Sydney, Australia Received on Fri Dec 12 1997 - 00:00:00 CST