Re: sqlplus question

Not sure if I agree on the exact point as you Daniel. But yes, there can be apps written which rely on doing things only after they are connected as another user.

For example consider a sql script which does this:

connect user1/pass1
select 'abc' from table1;

connect user2/pass2
drop table table1;

.. now in the above example, it would be a bad thing if it fails the second connection and drops object within the first user.

.. that is just an example though

Anurag

"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E6FE845.DEE74C47_at_exesolutions.com...
> Jerry wrote:
>
> > I already log in to server via sqlplus, then switched to another user,
> > failed due to wrong password. at this time, I was not connected to Oracle
> > server. But, I think it makes sense if I stay connected as old user. Is it
> > possible?
>
> No. Nor should it be. There is no reason for Oracle to trust that the person
> that couldn't log on properly is the same person that did.
>
> Daniel Morgan
>
Received on Wed Mar 12 2003 - 23:09:06 CST