Re: How Do I use Become User System Privileges

From: No Name <js_at_ameritech.net>
Date: Sun, 11 Jul 1999 15:12:56 -0500
Message-ID: <3788FAC8.DCE8E470_at_ameritech.net>


Use "connect user_id/password".

WolfAlpha wrote:
>
> Just to clarify my previous post--BECOME USER is one of the privileges
> granted to the built-in IMP_FULL_DATABASE role...
>
> Jeff S
>
> Pete Sharman <psharman_at_us.oracle.com> wrote in message
> news:378620FD.FA4D53A8_at_us.oracle.com...
> > Not really. To do full exports / imports you need the equivalent EXP /
> > IMP_FULL_DATABASE role. The BECOME USER privilege is used internally by
> the
> > import utility.
> >
> > The cleanest way to become another user is simply to log on as that user.
> If
> > you don't have their password, you probably shouldn't be doing it anyway
> ;)
> >
> > HTH
> >
> > Pete
> >
> > WolfAlpha wrote:
> >
> > > As far as I know, the BECOME USER privilege is granted to a user to give
> > > him/her the ability to do full imports (so they can specify the FROMUSER
> and
> > > TOUSER parameters--allowing them to import objects and data from one
> user's
> > > schema to another). There is an actual way to become another user in
> Oracle
> > > but you need to have the appropriate DBA level permissions to accomplish
> > > it...
> > >
> > > Jeff S
> > >
> > > Gary <noyfb_at_kma.com> wrote in message news:3785079A.11B11918_at_kma.com...
> > > > I am new to Oracle and I have a question that is probably real simple
> > > > but I can't find any documentation on it.
> > > > I can see from the documentation that you can assign to a User the
> > > > System Privilege "Become User" but there is
> > > > not a lot of information about what the "Become User" Privilege does
> or
> > > > how to actualy become a user. Can
> > > > anyone help. How does one become a user when connected as another
> user
> > > > with the privilege? Can this be done
> > > > from SQL Worksheet?
> > > >
> > > > Thanks,
> > > > Gary
> > > >
> > > >
> >
> > --
> > Regards
> >
> > Pete
> >
> >
Received on Sun Jul 11 1999 - 22:12:56 CEST

Original text of this message