Re: A synonym question

nsparta_at_gmail.com wrote:
> I have the following scenario:
>
> - Tables and views are in Schema1 and Schema2
> - Synonyms are created private under UserX
>
> this works fine no problem.
>
> Lately I created Schema3 and Schema4 to backup 1 and 2 respectively.
> Now I want to access these new schemas logging with userX and using
> the same synonyms, but the synonyms point to schema 1 and 2 how can I
> switch the same synonyms to point to schema3 and 4 dynamically?
>
> Thank You,
> Ziko
>

Not.

Accounts and schema's have a relationship. Your userX has schemaX; schemaX has synonyms pointing to One.table_1 and One.view_1 (without going into the discussion whether one stands for the account, or for the schema). One belongs to user1 (which is schema1). You cannot point to user4 'dynamically'.

Just drop the synonym, and re-create it while pointing to the other schema.

The other schema's being backups, I fail to see the point of this exercise. Do not touch your backup!

-- 

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up