On Oct 11, 1:18 am, "Binu K S" <[EMAIL PROTECTED]> wrote:
> hi ,
>
> It is
>
> all_triggers
>
> Thanks & Regards
> Binu
>
> On 10/11/08, raja <[EMAIL PROTECTED]> wrote:
>
>
>
>
>
> > Hi,
>
> > Please answer to the following question :
>
> > Which table will give the list of triggers in the schema ?
> > a. Need to know whether accessing/quering that table requires dba
> > rights or not?
> > b. is the table name, to get the list of triggers, is same for both
> > oracle 9i and 10g ?
>
> > With Regards,
> > Raja.- Hide quoted text -
>
> - Show quoted text -
No, it is not. The view used to answer the OPs question is
USER_TRIGGERS. He asked specifically about reporting triggers in the
current schema, not every trigger the connected user can access.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
