Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> SET ROLE in PL/SQL
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.)Received on Tue Dec 09 1997 - 00:00:00 CST
![]() |
![]() |