Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Privileges for Trigger

Re: Privileges for Trigger

From: Grue <grue_at_hotmail.com>
Date: 1998/02/06
Message-ID: <34db1abf.942187@128.158.254.10>#1/1

Schema A needs to be granted update privilege on B.Table2. I believe that's all that's required. The syntax would be:

     GRANT UPDATE ON B.Table2 TO A;

Hope that helps.

On Fri, 06 Feb 1998 10:02:08 +0100, Helmut Hahn <Helmut.Hahn_at_bitoek.uni-bayreuth.de> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US