Re: Sql Statement on Table Owned by Someone Else

From: Michael O'Neill <mjoneill_at_email.com>
Date: Tue, 12 Dec 2000 03:07:44 GMT
Message-ID: <4EgZ5.17284$x6.9347631@news2.rdc2.tx.home.com>

Yes. Investigate the CREATE SYNONYM command in your reference manuals.

"Mark Schenkel" <markschenkel_at_alpinesoftware.com> wrote in message news:3A35666C.149E6F4A_at_alpinesoftware.com...
> Is there a way to configure Oracle that when you run a Sql statement on
> tables owned by someone else you don't need to precede the table name
> with the owner?
>
> For example, if USER1 owns TABLE1, and I were logged in as USER2 but
> have access to USER1.TABLE1, is it possible to submit:
> SELECT * FROM TABLE1
> instead of
> SELECT * FROM USER1.TABLE1
>
> I have a front end application with lots of sql statements, none of
> which precede the table name with the owner. But I want other people to
> be able to use the application but with a different login name.
>
> Thanks, Mark.
>
Received on Mon Dec 11 2000 - 21:07:44 CST