Andreas Mosmann wrote:
> Maxim Demenko schrieb am 15.09.2005 in <dgcf4r$3mr$02$1_at_news.t-online.com>:
>
>> ORA 00942 error indicates very likely that you have not sufficient
>> privileges. The ability to select from v$session is probably covered
>> by the role, you need to grant as sys SELECT on v_$session to trigger
>> owner. Triggers can not be granted any privileges, only to users and
>> roles.
>
>
> I didn't expect that a trigger has not the same rights as the user. It
> still sounds strange for me, that you can grant anything but there is a
> difference between the user and his PL/SQL functions ...
>
> When I did this you said it worked fine. Thank you.
>
>> Best regards
>
>
>> Maxim
>
> Best regards
>
> Andreas
Go to tahiti.oracle.com and research AUTHID. The accompanying text
may be helpful for your understanding of PL/SQL.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Sep 16 2005 - 10:42:28 CDT
