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 -> Re: Refer other oracle schema.

Re: Refer other oracle schema.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 27 Dec 2005 09:52:00 +0100
Message-ID: <h202r19107m4451l5rra68tfnrng5e4mq8@4ax.com>


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 DBA
Received on Tue Dec 27 2005 - 02:52:00 CST

Original text of this message

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