Re: Accessing other users' tables

Erik Forkalsrud wrote:

> Is there any way I can skip the owner part in from of each table
> reference, so I don't have to rewrite all the queries throughout the
> application?

Grant an object rights (SELECT, INSERT, DELETE) to other users and create a synonym
for this object in the user's scheme (with the same name). If you have a lot of object, then
you'll better do it with script.

Sincerely.
S.P.Pohilko Received on Fri Jan 15 1999 - 17:13:58 CST