Re: Export full and users table

On Thu, 6 May 2004 10:39:01 +0200, Christophe <chocman_at_libertysurf.fr> wrote:

>Hello (it's me again...)
>
> I performed an export full with a user acount.
>my collegue import this dump file in another database : he did a import
>full the same user account than me and, as he had several 'insuficient
>privilege' messages, decide to perform the same import (full) but under
>System account.
>Is it normal that the import changed the user/password table ? The user
>account I used don't have privilège on those talbes...
>
>Chris

full imports execute the create user and alter user statements in the full export.
If the user running the import has privilege to run a full database import he has privilege to run those command. Check out the imp_full_database_role.

--
Sybrand Bakker, Senior Oracle DBA