Re: Migrating users and their passwords...

It is possible, but depends on the platforms.

If you are move from one platform from one vendor (say HP-UX ) then it will work. If you are moving from one platform with vendor A to another platform from vendor B (Say Novel to AIX), then it may not. It depends on the way the two hosts work with integers (big-endian vs little-endian, 'normal' int vs. short int, etc.). The impact is on the decode mechanism/algorithm. The same password string shows up in sys.dba_users, but the integer base causes it to be decoded differently on different platforms.

In article <35AA460D.3E1E_at_nortel.ca>,
  Dave Best <davidbe_at_nortel.ca> wrote:
> 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
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jul 14 1998 - 08:47:34 CDT