Synonyms and multiple schemas

From: Alex Vilner <avilner_at_usa.net>
Date: Thu, 30 Apr 1998 18:05:46 -0400
Message-ID: <3548F5BA.9E12817@usa.net>

Hello.

We have several user logins in the database. We also have several schemas in that same database. Users are made members of one of several groups, each affiliated with a schema. For simplicity, let's call schemas TEST and PROD, and their corresponding groups TEST_USERS and PROD_USERS. A user login cannot belong to two groups at the same time.

I would like to create a set of synonyms for a group, so that all members of the group can reference a set of objects, without having to prefix them with schema owner name. A set of PUBLIC synonyms will not work in this case, since we have 2 schemas.

I also do NOT want to create a set of synonyms for EACH user login. I was unable to create synonyms for a role. Is there a way to accomplish what we're trying to do?

Thank you in advance.

Alex Vilner Received on Thu Apr 30 1998 - 17:05:46 CDT