Re: Removing System Objects

Article View: borland.public.interbase.replication

Article #60

Back to borland.public.interbase.replication Previous Next

#60

From: Sergio H.
Date: Wed, 13 Oct 2004 16:54

32 lines
1869 bytes

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: <416d5dad@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!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>

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> <41671f87$1@newsgroups.borland.com> <416b0493$1@newsgroups.borland.com>
Subject: Re: Removing System Objects
Date: Wed, 13 Oct 2004 11:54:33 -0500
Lines: 34
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: <416d5dad@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1097686445 200.14.235.154 (13 Oct 2004 09:54:05 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message