RE: Synonym

From: ALTAIR, RSP_4 <RSP_4.ALTAIR_at_EU.RHODIA.COM>
Date: Thu, 13 Jul 2000 00:29:33 +0200
Message-Id: <10556.111896@fatcity.com>

Hi,

Is there any other methods to do this ? (I don't want sequence to be = owned
by b)

Thanks

Seb

> -----Message d'origine-----
> De: Wu, Yanhua [SMTP:yanwu_at_Mail.Donaldson.com]
> Date: mercredi 5 juillet 2000 22:58
> =C0: Multiple recipients of list ORACLE-L
> Objet: RE: Synonym

>=20
> There are couple of ways doing this, the logical one is to drop the =
public
> synonym that point to a.ta, since the object is no longer there; then
> create
> a public/private synonym point to b.ta for C.

>=20

> Yanhua.

>=20


> > -----Original Message-----

> > From:	ALTAIR, RSP_4 [SMTP:RSP_4.ALTAIR_at_EU.RHODIA.COM]

> > Sent:	Wednesday, July 05, 2000 12:34 PM

> > To:	Multiple recipients of list ORACLE-L

> > Subject:	Synonym

> >=20

> > Hi all,

> >=20

> > I have a little question :

> >=20

> > If user A creates a sequence TA and creates a public synonym for it

> > If user B drops sequence TA and recreates sequence TA

> >=20

> > User C wants to access the sequence, what should do user B ?

> >       1. Leave the current synonym ? (i saw that if i drop a =

object, his


> > public synonym is still here)

> >       2. Recreate 	the synonym ?

> >       3. Recreate sequence TA in A's shema ?

> >       4. ?

> >=20

> > Thank you for this little precision

> >=20

> > Sebastien Boutte

> >=20

> > --=20

> > Author: ALTAIR, RSP_4

> >   INET: RSP_4.ALTAIR_at_EU.RHODIA.COM

> >=20

> > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> > San Diego, California        -- Public Internet access / Mailing =

Lists

> > =

---

> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like =
subscribing).
> --=20
> Author: Wu, Yanhua
> INET: yanwu_at_Mail.Donaldson.com

>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing =

Lists


> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jul 12 2000 - 17:29:33 CDT