Re: How Do I use Become User System Privileges

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 - 11:19:09 CDT