Re: using dynanic views from a table trigger

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 03 Feb 2004 07:57:11 -0800
Message-ID: <1075823772.711238@yasure>

Michel Cadot wrote:

> "Jon" <aaa_at_bbb.ccc> a écrit dans le message de news:bvo0kk$8hf$1_at_unbe.sarenet.es...
>

>>I like to retrieve some columns of a dynamic view: V$INSTANCE from a trigger
>>but I do not know the name of the role I need to own ot the privileges
>>requiered to accomplish this task .. thanks
>>
>>

>
>
> If you want to retrieve data from v$instance in a trigger you must have the select
> privilege on it directly and not via a role.
>
> Regards
> Michel Cadot

Meaning someone with the appropriate privilege needs to do the following:

GRANT SELECT ON v_$instance TO <schema_name>

Note that the grant is on the object itself ... v_$ ... not on the synonym v$.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Tue Feb 03 2004 - 09:57:11 CST