Re: copying users from one Instance to another

Hi,

        The missing key word is VALUES.

                IDENTIFIED BY VALUES '.......'         select 'Create user "' || Name || '" identified by VALUES '''||passwords ||''' ;' from user$ ;
 select 'Alter user "' || Name || '" identified by VALUES '''||passwords ||''' ;' from user$ ;

-- 
Regards LANGE Francois.
flange_at_pt.lu
29A Route du vin.
L5450 Stadtbredimus.
Grand Duchy Of Luxembourg.
TEL (int) 352 697412.(*)
CEL(int) 352 021193652(*)
Phone numbers are variable length in Luxembourg.
Grand Duchy Of Luxembourg is a small country 80 miles on 60 miles between
France,Germany and Belgium.
-- 
Regards LANGE Francois.
flange_at_pt.lu
29A Route du vin.
L5450 Stadtbredimus.
Grand Duchy Of Luxembourg.
TEL (int) 352 697412.(*)
CEL(int) 352 021193652(*)
Phone numbers are variable length in Luxembourg.
Grand Duchy Of Luxembourg is a small country 80 miles on 60 miles between
France,Germany and Belgium.

Kevin Brand <kevinx_at_sequel.com> wrote in article
<01bd9ec5$b6a00c10$f15c5b8f_at_b11a22>...


> Is it possible to copy passwords from one engine to another?


> 

> I've attempted to adjust the passwords in a throw-away instance by

> manipulating the PASSWORD column in USER$, but this didn't work.  I'm

 sure


> there's a trick out there somewhere!


> 

> Any suggestions?

> 

> Thanks

> 

> -Kevin

> 

> I've cross-posted here because sometimes my posts don't show up on

> ..oracle.server!  

> -- 

> 

> remove the x for an email reply

>