Article View: borland.public.interbase.replication
Article #63Re: Removing System Objects
From: Steve Ball
Date: Sat, 16 Oct 2004 11:06
Date: Sat, 16 Oct 2004 11:06
43 lines
2472 bytes
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-mailReferences:
<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