๐Ÿš€ go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.replication
Article #63

Re: Removing System Objects

#63
From: Steve Ball
Date: Sat, 16 Oct 2004 11:06
43 lines
2472 bytes
Well the Drop Trigger stuff normally is done via ReplManager.
My guess is that you might have been dropping a scheme but not the one in 
the database. Its all done via the scheme numbers and this does work. Its 
careful as you could have more than 1 scheme in a database.
Steve

"Sergio H." <topx@geocities.com> wrote in message 
news:416d5dad@newsgroups.borland.com...
> Oh yes, REVOKE.  But I ended up using statements directly to the RDB$
> tables.
>
> So, after using "Remove System Objects" in the ReplManager, one has to 
> run:
>
> DROP TRIGGER REPL_GEN_SEQNO;
> DROP TABLE MANUAL_LOG;
> DROP TABLE REPL_LOG;
> DROP TABLE REPL_SEPARATOR;
> DELETE FROM RDB$USER_PRIVILEGES WHERE RDB$USER LIKE 'REPL%%';
>
> And I think this sould be done by the ReplManager.
>
> Finally, I didn't want to use IBReplicator because it never went with my
> trigger-generated primary keys.  I'm trying to post here the message I got
> rejected from ibp_replicator@lists.ibphoenix.com because of being >17 Kb
> long.
>
> Regards,
>
> Sergio H. Guerrero R.
>
> "Steve Ball" <SteveBall@noSpam.uku.co.uk> escribi๏ฟฝ en el mensaje
> news:416b0493$1@newsgroups.borland.com...
>> I can't remember the exact syntax, but just run an SQL command to revoke
>> privilages.
>> something like
>>
>> REVOKE ALL on MYTABLE from REPL$XXX
>> hth
>> Steve
>>
>
> 
Technical Details
Message-ID: <417100cd@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!colt.net!peernews3.colt.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <40a22827$1@newsgroups.borland.com> <40a7501d@newsgroups.borland.com> <41671f87$1@newsgroups.borland.com> <416b0493$1@newsgroups.borland.com> <416d5dad@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: f89d7,925ac6238305ae55
X-Google-Attributes: gidf89d7,public
X-Google-Language: ENGLISH,ASCII
From: "Steve Ball" <SteveBall@noSpam.uku.co.uk>
Newsgroups: borland.public.interbase.replication
References: <40a22827$1@newsgroups.borland.com> <40a7501d@newsgroups.borland.com> <41671f87$1@newsgroups.borland.com> <416b0493$1@newsgroups.borland.com> <416d5dad@newsgroups.borland.com>
Subject: Re: Removing System Objects
Date: Sat, 16 Oct 2004 12:06:54 +0100
Lines: 45
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 62.107.38.134
Message-ID: <417100cd@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1097924813 62.107.38.134 (16 Oct 2004 04:06:53 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!colt.net!peernews3.colt.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail