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!

Grant read on triggers.

657594Dec 5 2008 — edited Dec 5 2008
Hello,

I need some advice from all of you.

I own one schema and I would like one of my user to be able to read all table, triggers, package and view, it's only READ-ONLY. I understand that if I grant alter any trigger to that user then he/she can then disable or enable the triggers. What privilege should I grant to this user?

Thank you in advance.

Ao
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 2 2009
Added on Dec 5 2008
3 comments
838 views