Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
#general-database-discussions
7 comments
268 views