Re: How to export oracle user

Bob Yeh wrote:
>
> Hi,
>
> I am trying to export Oracle users from one database to another.
>
> If I import the users base on user name then I have to create the user
> on the target database first(I don't want to change usres' passwd).
>
> I dod't want to do an full import either because there are unwanted
> users and it is going to import sys/system objects also, right?
>
> What is the best way to do it?
>
> Thanks.
>
> Bob

Look in DBA_USERS for the password field. You CAN precreate the user with the old password.

If in DBA_USERS, the password field says "123ASD456QWE" then create the user with

create user xyz identified by values '123ASD456QWE';

Use DBA_SYS_PRIVS to find what privs they had in the old database and away you go...

Cheers
Connor McDonald
BHP Iron Ore
Perth Australia

-- 
Connor McDonald
Systems Administrator-Unix/Oracle
BHP Iron Ore
"You're not drunk if you can lie on the floor without holding on"
            - Dean Martin