Re: DBA? - copying users to another instance - DBA?

On Mon, 30 Sep 1996 13:58:05 LOCAL, SXRGM_at_alaska.edu (Harry Lime) wrote:

>I need to copy several users from one instances to another.
>I have written a sql script to create the create user syntax;
>however, I had to hard code the same password on each create
>statement. Is there a way to get the encoded password in the
>create syntax? (these are just users with no objects to be moved).
>I have heard of "become user", will this help?

You can do CREATE USER username IDENTIFIED BY VALUES '<encoded password string here>';

It's very easy, really. 8) Received on Thu Oct 03 1996 - 00:00:00 CEST