Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!i40g2000cwc.googlegroups.com!not-for-mail From: "extents" Newsgroups: comp.databases.oracle.server Subject: Re: ALTER USER scott IDENTIFIED BY VALUES ??? Date: 4 Apr 2006 16:18:59 -0700 Organization: http://groups.google.com Lines: 34 Message-ID: <1144192739.940159.234990@i40g2000cwc.googlegroups.com> References: <1144134860.277624.218190@v46g2000cwv.googlegroups.com> <443295d5$0$13260$636a55ce@news.free.fr> NNTP-Posting-Host: 203.39.205.154 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1144192745 31264 127.0.0.1 (4 Apr 2006 23:19:05 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 4 Apr 2006 23:19:05 +0000 (UTC) In-Reply-To: <443295d5$0$13260$636a55ce@news.free.fr> User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 4.0; SDE 2/12/02 1.0),gzip(gfe),gzip(gfe) X-HTTP-Via: 1.1 ISA1 Complaints-To: groups-abuse@google.com Injection-Info: i40g2000cwc.googlegroups.com; posting-host=203.39.205.154; posting-account=7s1VBw0AAAB60DdHQ1XVckYm-qvYK-8l Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:264858 Thanks guys for the useful info. Mark I couldnt find that script on the metalink but came across other useful scripts while searching yours!!! Michel Cadot wrote: > "extents" a =E9crit dans le message de news: 11441348= 60.277624.218190@v46g2000cwv.googlegroups.com... > | Hi > | Is there a way to set all the users password on database B as database > | A? version 9.2.0. > | > | thanks > | > > On database A: > > Set verify off > Set space 0 > Set heading off > Set feedback off > Spool t.sql > Select 'Alter user '||username||' identified by values '''||password||''= ';' > from dba_users > where username not in ('SYS','SYSTEM',...) > order by 1 > / > Spool off > > ftp t.sql to database B server and execute it. >=20 > Regards > Michel Cadot