SET ROLE in PL/SQL

From: Jerry Apfelbaum <japfelbanospam_at_ican.ca>
Date: 1997/12/09
Message-ID: <348E1587.76DE803_at_ican.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; 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