Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Refer other oracle schema.
On 26 Dec 2005 23:16:26 -0800, "B" <bhawin13_at_gmail.com> wrote:
>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
You either have set up a synonym for l2.t1
and either you have
- granted select to public
- or you have the SELECT ANY TABLE privilege as l1 (because you have
the DBA role or some other powerful role)
-- Sybrand Bakker, Senior Oracle DBAReceived on Tue Dec 27 2005 - 02:52:00 CST