Re: Synonym

Create the sequence as C (if that's who you want to be the owner), then grant select on the sequence to B. Then a private synonym owned by B for C.sequence. Example:

connect C/passwd
create sequence testseq <.....> ;
grant select on testseq to B ;

connect B/passwd
create synonym testseq for C.testseq ;

HTH,
Suzy

"ALTAIR, RSP_4" wrote:
>
> 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
> > À: Multiple recipients of list ORACLE-L
> > Objet: RE: Synonym
> >
> > 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.
> >
> > Yanhua.
> >
> > > -----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
> > >
> > > Hi all,
> > >
> > > I have a little question :
> > >
> > > If user A creates a sequence TA and creates a public synonym for it
> > > If user B drops sequence TA and recreates sequence TA
> > >
> > > 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. ?
> > >
> > > Thank you for this little precision
> > >
> > > Sebastien Boutte
> > >
> > > --
> > > Author: ALTAIR, RSP_4
> > > INET: RSP_4.ALTAIR_at_EU.RHODIA.COM
> > >
> > > 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).
> > --
> > Author: Wu, Yanhua
> > INET: yanwu_at_Mail.Donaldson.com
> >
> > 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).
> --
> Author: ALTAIR, RSP_4
> INET: RSP_4.ALTAIR_at_EU.RHODIA.COM
>
> 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
Received on Wed Jul 12 2000 - 22:16:37 CDT