Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!j33g2000cwa.googlegroups.com!not-for-mail
From: "Mark D Powell" <Mark.Powell@eds.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: ALTER USER scott IDENTIFIED BY VALUES ???
Date: 4 Apr 2006 06:50:18 -0700
Organization: http://groups.google.com
Lines: 15
Message-ID: <1144158618.274123.160250@j33g2000cwa.googlegroups.com>
References: <1144134860.277624.218190@v46g2000cwv.googlegroups.com>
   <1144142303.807464.175630@z34g2000cwc.googlegroups.com>
NNTP-Posting-Host: 192.85.50.1
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1144158623 21889 127.0.0.1 (4 Apr 2006 13:50:23 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 4 Apr 2006 13:50:23 +0000 (UTC)
In-Reply-To: <1144142303.807464.175630@z34g2000cwc.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: j33g2000cwa.googlegroups.com; posting-host=192.85.50.1;
   posting-account=J7QqBQwAAABTieek3RP_669Gs2iATWzr
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:264795

You can set the passwords for the users on database B to the values in
database A the same way Oracle imp/exp does it.

Depending on how close these databases are in design you might be able
to drop the non-owner users and recreate them via an import of a rows=n
export.

Or it may be easier and cleaner to just use SQL to generate the alter
user statements on database A and then run the alter script on database
B.

I have posted a create users generation script on metalink in the past.

HTH -- Mark D Powell --