SET ROLE in PL/SQL

From: Jerry Apfelbaum <japfelba_at_ican.ca>
Date: 1997/12/09
Message-ID: <348E120A.DA60AC75_at_nospamican.ca>#1/1


[Quoted] [Quoted] We have not had any success with trying to execute the SQL command:

[Quoted]           SET ROLE ThisRole IDENTIFIED BY ThisPassword; [Quoted] 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.)
Received on Tue Dec 09 1997 - 00:00:00 CET

Original text of this message