Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ALTER USER scott IDENTIFIED BY VALUES ???

Re: ALTER USER scott IDENTIFIED BY VALUES ???

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 4 Apr 2006 17:50:47 +0200
Message-ID: <443295d5$0$13260$636a55ce@news.free.fr> 






"extents" <extents_at_gmail.com> a écrit dans le message de news: 1144134860.277624.218190_at_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.



Regards


Michel Cadot
Received on Tue Apr 04 2006 - 10:50:47 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US