๐Ÿš€ go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Removing System Objects

#58
From: Sergio H.
Date: Fri, 08 Oct 2004 23:15
46 lines
2330 bytes
Greetings...

But after ReplManager has removed "System Objects" (tables and triggers), if
you backup the database, you notice there is some priveledges for a user
called REPL$XXX... and that user doesn't appear in isc4.gdb (or
security.fdb).

Do you know how to remove every trace of the Replicator?

TIA,

Sergio H.

"Steve Ball" <SteveBall@noSpam.uku.co.uk> escribi๏ฟฝ en el mensaje
news:40a7501d@newsgroups.borland.com...
> Easiest way is attach to the database from the other server via
ReplManager
> and choose remove system objects, if you can't do that then you can
manually
> remove the 3 REPL tables (REPL_LOG etc)
> You then need to remove all the triggers that are on each table that you
> replicate (typically there are 3 per table to deal with insert, update and
> delete) not sure if you need to remove the triggers first as they depend
on
> the REPL_... tables.
>
> First way is defenately the easiest, but depending on the line you use to
> connect to the database (ie local network, wan, modem dial up) this could
> take a while.
>
> HTH
> Steve
>
>
> "Steve Weston" <sweston{no spam}@westonmuir.com> wrote in message
> news:40a22827$1@newsgroups.borland.com...
> > I have restored an IB 7.1 db onto another server. How do I remove the
repl
> > objects (tables, triggers, etc.)?
> >
> > --
> > Steven S. Weston
> >
> >
>
>
Technical Details
Message-ID: <41671f87$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newshosting.com!nx02.iad01.newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
References: <40a22827$1@newsgroups.borland.com> <40a7501d@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: "Sergio H." <topx@geocities.com>
Newsgroups: borland.public.interbase.replication
References: <40a22827$1@newsgroups.borland.com> <40a7501d@newsgroups.borland.com>
Subject: Re: Removing System Objects
Date: Fri, 8 Oct 2004 18:15:58 -0500
Lines: 48
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 200.14.235.154
Message-ID: <41671f87$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1097277319 200.14.235.154 (8 Oct 2004 16:15:19 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newshosting.com!nx02.iad01.newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail