Dear sir,

I sent the mail as below yesterday, Paul Beach / Dimitry Sibiryakov in ibp_replicator@... suggested me report it to FB support list. I suppose it like a problem of grant limitation bug as before. pls advise.

Best Regards

Roy

----- Original Message -----
From: "Roy Zhao" <roy.zhao@...>
To: <ibp_replicator@...>
Sent: Tuesday, March 13, 2007 11:10 AM
Subject: replication problem - like grant limitation


> Dear All,
>
> I got the problem as below, I think it's maybe a problem with grant limitation bug.
>
> My version is: FirebirdCS-2.0.1.12810-0
>
> [root@tpservertest ~]# /opt/firebird/bin/isql /db/telepad4-sh.gdb -user root -password 1111111 -role TELEPAD2_USER
> - select works. But update still does not.
>
> Even more interesting:
>
> 1. I have disabled all triggers:
> alter trigger REPL$10_1100_U_1_1 inactive;
> alter trigger REPL$11_1200_U_1_1 inactive;
> alter trigger REPL$12_1300_U_1_1 inactive;
> alter trigger REPL$13_1400_U_1_1 inactive;
> alter trigger REPL$2_216_U_1_1 inactive;
> alter trigger REPL$3_132_U_1_1 inactive;
> alter trigger REPL$4_494_U_1_1 inactive;
> alter trigger REPL$5_591_U_1_1 inactive;
> alter trigger REPL$6_704_U_1_1 inactive;
> alter trigger REPL$7_790_U_1_1 inactive;
> alter trigger REPL$8_901_U_1_1 inactive;
> alter trigger REPL$9_1001_U_1_1 inactive;
>
> 2. I have enabled 1st one:
> alter trigger REPL$10_1100_U_1_1 active;
>
> 3. Tried update - it works.
>
> 4. Disabled all triggers again.
>
> 5. Enabled 2nd one:
> alter trigger REPL$11_1200_U_1_1 active;
>
> 6. Tried update - it does not work.
>
> I have revoked all individual insert rights to REPL_LOG:
>
> revoke insert on repl_log from public;
>
> and then I have granted insert to public:
>
> grant insert on repl_log to public;
>
> And now it seems to be working.
>
> Any idea?
>
> Best Regards
>
> Roy