Re: Privileges for Trigger
Date: 1998/02/10
Message-ID: <34E02275.1EB4DDAD_at_NOSPAM.dk.oracle.com>#1/1
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.
Received on Tue Feb 10 1998 - 00:00:00 CET