Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SET ROLE in PL/SQL
raymond allo <raymond_at_ramavista.com> writes:
>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.
[...]
>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.
What's wrong with dbms_session.set_role?
In SQL*Plus, "exec dbms_session.set_role('foo identified by bar');"
Works Great!
-- Nathan D. Hughes <nhughes_at_well.com> Computer Consultants of America, Inc.Received on Fri Dec 12 1997 - 00:00:00 CST