๐Ÿš€ go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Removing System Objects

#59
From: Steve Ball
Date: Mon, 11 Oct 2004 22:09
60 lines
2724 bytes
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

"Sergio H." <topx@geocities.com> wrote in message 
news:41671f87$1@newsgroups.borland.com...
> 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: <416b0493$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.frii.net!newsfeed.frii.net!news.compaq.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
References: <40a22827$1@newsgroups.borland.com> <40a7501d@newsgroups.borland.com> <41671f87$1@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>
Subject: Re: Removing System Objects
Date: Mon, 11 Oct 2004 23:09:30 +0100
Lines: 62
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: <416b0493$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1097532563 62.107.38.134 (11 Oct 2004 15:09:23 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.frii.net!newsfeed.frii.net!news.compaq.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail