Re: Oracle equivalent to unix 'su - username'... connecting as someone else

Easiest way, is to look at the dba_users table, which holds an encrypted version of the password. If you do a "select username, password from dba_users where user_name = '????';", and then save this to a file - DO NOT DELETE IT. You can then use the 'alter user xxxx identified by yyyy;' statement to change the users password to something that you know.... When you have finished, you can change it back to its previous value: alter user xxxxx identified by values '<paste password string from file here>';

In article <35E9C363.E6B96EB1_at_u.washington.edu>,   mikkro_at_hbsi.com wrote:
> One can always close your current connection and open a connection.
>
> You cannot normally connect as a user unless you have the password OR
> you change the password/security system to use external log in.
>
> You can change to some user via 'su - username'
> Then connect as that user.
>
> More correctly why do you want to connect as some user? As a dba, there
> generally is only a few user that I would use. Generally, they are
> sys or internal -- to do system work
> schema owner(s) -- the owner of the main schema. Generally if
 the
> DBA is
> the maintainer of the database, he/she
> has the password.
>
> user -- generally to create the inital password. or
> test a problem.
>
> All work can be done in the sys/internal or the schema owner.
 Generally,
> one
> does not have to do work on the other users. You can delete or destroy tables,
> data,
> etc.
>
> Mike Krolewski
>
> oracle_at_nettwerk.com wrote:
>
> > Hi there-
> >
> > I was wondering if anyone could possibly help me...
> >
> > I have been granted DBA privs on an Oracle 8.0.5 database, and after
> > connecting as DBA, would like to connect as another user in that database...
> > but I don't want to have to know their password.
> >
> > Similar to 'su - username' as root on a unix box.
> >
> > Any ideas?
> >
> > I have to do some work in some schemas while a couple of people are on
> > vacation (no passwords!), and I can't just change the password without
> > breaking some other things like OAS links, etc. Being able to "su" would be
> > way easier.
> >
> > Thanks ....
> >
> > ...jeff
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 01 1998 - 00:00:00 CDT