Re: Cannot see rows in ALL_TRIGGERS

There are three basic types of system views upon Oracle.

USER_TABLES, USER_INDEXES, etc. contain details of objects defined within your own schema (ie. owned by you).

ALL_TABLES, ALL_INDEXES, etc. contain details of objects which can be accessed by you.

DBA_TABLES, DBA_INDEXES, etc. contain details of all objects (regardless of who they are owned by or whether you can access them).

Therefore, I would conclude that you cannot see the triggers in question because they are not defined in your schema and you don't have 'access' to them (whatever that means).

Help this helps.

Ron C. wrote in message <351287b9.803367_at_news.voyager.net>...
>I just got an ID to access our production database via SQLPLUS. When I
>do "SELECT * FROM ALL_TRIGGERS" it comes back with 0 rows, but
>another user (the DBA) says he gets 179 rows. I thought that if you
>can "see" the table, then you can at least SELECT.
>Can anyone help me?
>Please remove the NOSPAMME if you reply by mail
>Thanks,
>Ron
Received on Sat Mar 21 1998 - 00:00:00 CST