Re: How Do I use Become User System Privileges

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 Fri Jul 09 1999 - 16:41:48 CDT