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

On Sun, 30 Aug 1998, Michael Krolewski 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.

This is assuming that 1) I have root on the box and 2) that each schema has an account on the machine. Both of these assumptions are incorrect.  

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

I have been contracted by another company to plan their 7->8 migration and make some tuning/programming changes. It is much easier to edit pl/sql when connected as the owner of that code; especially since I do most of my work from the command line from a remote (ssh) connection with some scripts that I've written to export the schema's source.

>
> 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
>
>
>
>
>
Received on Mon Aug 31 1998 - 00:00:00 CDT