Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ALTER USER scott IDENTIFIED BY VALUES ???
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" <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 - 18:18:59 CDT