Re: all_triggers

dw wrote:
> Hello
>
> I don't want to grant the users access to views such as dba_triggers
> or dba_constraints. But there is requirement that the user needs to see
> the triggers owned by some other schema. Is there a way for a user to
> see the data from all_triggers when he doesn't own the trigger? Any
> ideas? Version 9.2.0
>
> Thanks
> D

What do you think is in ALL_TRIGGERS?
What do you think the purpose of the view is?

If you are unfamiliar with this view then create a table with a trigger in a schema. Grant rights to the table to another schema. Then log onto that other schema and learn how it all works.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)