Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: connect to another user

Re: connect to another user

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/05/23
Message-ID: <zIkW4.205926$Tn4.1777199@news1.rdc2.pa.home.com>#1/1

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...

> 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
Received on Tue May 23 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US