From: nhughes@well.com (Nathan D. Hughes) Subject: Re: SET ROLE in PL/SQL Date: 1997/12/12 Message-ID: <66s246$od4$1@was.hooked.net>#1/1 References: <348E1587.76DE803@ican.ca> <34907138.713C@ramavista.com> Organization: Whole Earth Networks News Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc,comp.databases.oracle.tools raymond allo 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 Computer Consultants of America, Inc.