Re: Privileges for Trigger

From: Alexei Fox <alexei_fox_at_yahoo.com>
Date: 1998/02/06
Message-ID: <34DB14AA.40D03897@yahoo.com>#1/1

Schemaowner B should grant alter on Table2 to Schemaowner A: GRANT ALTER ON Table2 TO A

Regards,
Alexei Fox

Helmut Hahn wrote:

> Hallo!
>
> I have a simple question. Concern two schemas say A and B. I need an
> update Trigger on A.Table1
> with 'update B.Table2 set ...'
> How must provileges be granted to make this work? I only succeded with
> system privilege 'alter any table' to schemaowner A.
> But this is not what I want. What am I doing wrong?
>
> Helmut
Received on Fri Feb 06 1998 - 00:00:00 CST