Re: spawning a new connection within pl/sql

Thanks for the help, Vladimir. I'll look into the DBMS_SYS_SQL package.

Mark

"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:b73lph$4h5$1_at_babylon.agtel.net...
> "enquiry" <noone_at_hometownz.co.uk> wrote in message
news:b73gl6$uv$1_at_sparta.btinternet.com...
> > I'm trying to work out how to spawn a new connection from within pl/sql.
> >
> > I've been trying to work out how to use the "proxy user" functionality
but
> > can't work out how to implement it. I can issue the grant "connect
through"
> > to users but then can't work out how to make it work. I may be barking
up
> > the wrong tree anyway.
>
> As I understood this "proxy user" feature, it can only be used from the
> middle tier through OCI (and JDBC?) and can't be used on server side.
> I don't think it's really possible to spawn new connection on the server
> side - creating connections is at client's discretion, so reconnection
with
> different credentials should be implemented there.
> You may want to look at DBMS_SYS_SQL.PARSE_AS_USER()
> functionality, but it will not allow you to reconnect, it will only allow
> you to run certain DDL and DML as another user (I believe IMP
> uses this functionality.)
>
> --
> Vladimir Zakharychev (bob_at_dpsp-yes.com)
http://www.dpsp-yes.com
> Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
applications.
> All opinions are mine and do not necessarily go in line with those of my
employer. Received on Thu Apr 10 2003 - 08:39:41 CDT