Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Refer other oracle schema.

Refer other oracle schema.

From: B <bhawin13_at_gmail.com>
Date: 26 Dec 2005 23:16:26 -0800
Message-ID: <1135667786.684963.288050@f14g2000cwb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US