I love the su.sql and modify a little bit so that it will work when connect to a remote database.

-- export SQLPATH
SET VERIFY OFF
SET FEEDBACK OFF

whenever sqlerror exit
column password new_value pw
column instance_name new_value iname

declare
l_passwd varchar2(45);
begin
select password into l_passwd
from sys.dba_users
where username = upper('&1');
end;
/

select password
from sys.dba_users
where username = upper( '&1' )
/

select instance_name
from sys.v_$instance
/

alter user &1 identified by Hello;
connect &1/hello@&iname

alter user &1 identified by values '&pw';

whenever sqlerror continue
@login
SET VERIFY ON
SET FEEDBACK ON

Your ans is good but does not solve my problem.

Actually I am working on discoverer. I have 3 DBs (Databases). User1 and User2 are on DB1 AND DB2.

On the 3rd DB, I have:
==> DB Links to DB1 and DB2 pointing to User1 and User2
==>Three users DISC, X and Y.
==> DISC is having the EUL and Business areas say User1BusinessArea and User2BusinessArea. Access on User1BusinessArea is given to user X and access on User2BusinessArea is given to user Y.

Down the Line, I move:
==>User2 from DB2 to DB1
==>DISC, X, Y from DB3 to DB1

So now we have DB1 with all the users. If I try to open the Workbooks that were created earlier it would give me error because the DB link is hard-cored in the EUL Tables.

So how do i solve this problem?

Would be greatful if you could give me the solution.

Regards,

The reference </code> http://asktom.oracle.com/~tkyte/Misc/su.html <code>does not work. As usual the answer is very good and useful.