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: Helmut Hahn <Helmut.Hahn_at_bitoek.uni-bayreuth.de>
Date: 1998/02/09
Message-ID: <34DEB063.224D26F4@bitoek.uni-bayreuth.de>#1/1

Grue wrote:

> 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.

Yes thats it. I cant figure out why this does not work when a grant a role to A which has update privileges on B.Table2. Could please anybody give me hint on this?

Thanks Helmut Received on Mon Feb 09 1998 - 00:00:00 CST

Original text of this message

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