I created a report on Oracle Database using JDBC connection.

I created on a schema say USER1. When I run report and See View SQL it show the query For Instance:

SELECT TAB1.C1, TAB1.C2
 FROM USER1.TAB1

Now I want this report to be run on another schema say USER2 that is structurally alike on the same database instance (SID),and Same Host.
For this I tried the following tricks to change the SQL like below.

SELECT TAB1.C1, TAB1.C2
 FROM USER2.TAB1

1. I log off and again Log on with the USER2 username and its password.
But when I View SQL its unaltered :-(


2. I created a new JDBC Connection and logged in with USER2, but
when I View SQL its unaltered :-( :-@

How can I recompile/update/change the SQL schema alias????

Thanks in Advance