Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

triggers

407048Jul 27 2005 — edited Aug 1 2005
I have two users A and B on the same database. User A owns 10 tables and also has triggers associated with its tables.

User B has all all table privileges(in terms of DML, DDL, etc) to User A's schema tables and other objects.
User B can list out all the tables by a
SELECT * FROM ALL_TABLES

and thus see the list of tables it has access.

I was hoping that the trigger information can also be viewable by User B.
But when I said
SELECT * FROM ALL_TRIGGERS , I am not able to see any records.
What can user B do to view the list of all the triggers of user A with the trigger code ?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 29 2005
Added on Jul 27 2005
7 comments
274 views