Refer other oracle schema.

Hello,

I have 3 schema. ( l1, l2,l3 ).
My asp code uses l1 user name to connect oracle server. I have copied 6 table from l2 to l3 schema. (Table with same name , same data and all other attribute.)

Now when I try to execute query like
Select * from t1
--Schema name is not used as prifix to table name.
--Where t1 is table in schema l2 and l3 both with all same attribute
and same data.

When I execute query
Select * from t1
It always give result from l2.t1
I have checked by changing record value in l3.t1 and l2.t1

Previously l1 have select permission for l1.t1 and l2.t1. I have then remove select permission from only l2.t1 for l1.

Still I am getting result from l2.t1 when I execute query Select * from t1

Anybody have idea what is wrong?

Thanks
B Received on Tue Dec 27 2005 - 01:16:26 CST