Re: Privileges for Trigger

My guess is that you are trying to access the object with PL/SQL.

It is not possible to use object privileges obtained through a role from within PL/SQL.
Instead you must grant the privileges directly to the owner of the PL/SQL object
(package, procedure, function).

The reason is that the PL/SQL compiler cannot check privileges at compile-time if
the object is supplied at run-time.

/Jesper

Helmut Hahn wrote:

> 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

--
.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.

|
|
|                            Jesper
 Søndergaard                              |
|                            Technical
 Analyst                              |
|
|
| Email:     jsoender_at_dk.oracle.com                 Oracle
 Danmark           |
| Office:    +45 4480 8081                          Lautrupbjerg
 2-6         |
| Direct:    +45 4480 4269                          DK-2750
 Ballerup         |
|
|
'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'

         The statements and opinions expressed here are my own and
         do not necessarily represent those of Oracle Corporation.