Synonyms are a pain!

From: Robert Wagner <RobertWagner_at_alum.mit.edu>
Date: 2000/05/04
Message-ID: <a4kQ4.5323$J81.40251@newsr1.maine.rr.com>#1/1

Here's what I understand now:

In order to allow any user other than a schema owner to access a schema object, it's necessary to create a synonym for each and every object or to use the syntax

schema_owner.object_name

when referencing it. To make matters worse, the synonyms don't export with the schema they reference, so they're a pain to ship to a new installation.

Is there any simpler, more reliable way to allow a designated group of users to access a schema's objects without using the above syntax?

Cheers >>>>>>>>>>>> Robert R. Wagner
ExpanTest, Inc.
22 Monument Square, Suite 503
Portland, ME 04101-4031
http://www.gwi.net/expantest/
robertwagner_at_alum.mit.edu Received on Thu May 04 2000 - 00:00:00 CDT