When I move users from one instance to another I generate the create user
statement from the current instance as follows:
SELECT 'CREATE USER '||USERNAME||' IDENTIFIED BY VALUES '''||PASSWORD||
''' DEFAULT TABLESPACE '||DEFAULT_TABLESPACE||' TEMPORARY TABLESPACE
'||TEMPORARY_TABLESPACE,'PROFILE '||PROFILE||';'
FROM DBA_USERS WHERE ..........;
Dave Best wrote in message <35AA460D.3E1E_at_nortel.ca>...
>Hey all.. quick question. I am told that it is possible to
>move users between databases and still keep their password. For
>example, user on system A has password XXX, encrypted equals YYY.
>Can I do something like this on system B?:
>
> create user "JOHN" identified by YYY;
>
>or after the user is created do a
>
> alter user "JOHN" identified by YYY;
>
>This way, the user can login to machine B and still have the same
>password. For some reason I can't get this to work, even tho I am
>told it is possible. (FYI: The encrypted passwords on the separate
>systems
>are identical.)
>
>Any help would be greatly appreciated.
>
>Dave
Received on Tue Jul 14 1998 - 12:26:10 CDT
