Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: connect to another user
When you call a procedure owned by another user, you actually run as that user, not as yourself. This may be what you are looking for. There are also ways to change a password of another user, connect and then change it back to what it was.
select password from dba_users.
alter user ... identified by whatever;
connect .../whatever
alter user ... identified by values 'the value you saw from the select';
But I am pretty sure that you can't connect to another user via PL/SQL because it requires that you create a new connection, and in order to do that you would disconnect from the current session (what you are running). If I am wrong I would expect it would be something in the dbms_system routines (that you can't see).
-- Robert Fazio, Oracle DBA rfazio_at_home.com remove nospam from reply address http://24.8.218.197/ "James Chappell" <james_at_rees-chappell.demon.co.uk> wrote in message news:zm+zyGAM9aK5EwJu_at_rees-chappell.demon.co.uk...Received on Tue May 23 2000 - 00:00:00 CDT
> I saw a routine to do this in sql - the process is described in a book I
> was reading at work today. I'll look it up tomorrow and post the code.
> If it can be done in sql, I guess it can be done in pl/sql!
>
> In article <nulgisk5o6nqn024sg8pkk99no6uhd8n34_at_4ax.com>, Bernardo
> <begheb_at_tin.it> writes
> >i wanto to create a procedure in pl/sql (oracle 7.3)
> >for connecting to another user without change his password
> >can anyone help me?
> >thx in advance
>
> --
> James Chappell