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