"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@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 - 06:49:29 CDT
