Re: A synonym question

From: <nsparta_at_gmail.com>
Date: Fri, 25 Jan 2008 12:28:18 -0800 (PST)
Message-ID: <3ee010ac-a669-46f5-b8ad-2e41a48f091c@i7g2000prf.googlegroups.com>


On Jan 25, 3:14�pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> nspa..._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- Hide quoted text -
>
> - Show quoted text -

The new created schemas are actually an archive not backup my appologies.
I want to connect with the same user and dynamically switch between main database and archive one.

Thank You,
Ziko Received on Fri Jan 25 2008 - 14:28:18 CST

Original text of this message