Sync passwords from one database to another
Here is a simple way to syncronize schema passwords from one Oracle database to another. On the source database run the following sqlplus command: SQL> select ‘alter user ‘ || username || ‘ identified by values ”’|| password ||”’;’from dba_users where username in (‘GMADMIN’,’GM_0′,’GM_0_REPORT’,’GM_0_STATS’); That will produce the following output which you can run on [...]
