Re: TOAD: SQL Script execution

From: Matthias Hoys <anti_at_spam.com>
Date: Fri, 9 Jun 2006 22:02:05 +0200
Message-ID: <4489d3be$0$10461$ba620e4c@news.skynet.be>

"null" <null_at_null.it> wrote in message
news:4489cb12$0$36935$4fafbaef_at_reader3.news.tin.it...
> Yes!!
>
> If I modify the query with user.table it works OK!!!
>
> How Can modify it for use the query with the tablename without "user."
>
> Thanks

You could execute the query with the table owner (user), or create a synonym for the other user.

create synonym other_user.table for user.table

and grant the necessary rights to the other user.

Matthias Received on Fri Jun 09 2006 - 15:02:05 CDT