Re: Privileges for Trigger

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