Re: How Do I use Become User System Privileges

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
>
>
Received on Thu Jul 08 1999 - 21:21:29 CDT