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!

What is the privilege to see definition of a view or SQL of a view

sweetritzSep 1 2014 — edited Sep 2 2014

Hi DBAs,

I have granted the user to select all the views (read only access) with following query.


select 'grant select on '|| OWNER || '.' ||view_name || ' to ' || '<USERNAME>;' from dba_views;


Now the problem is the user after connecting to DB via SQL developer is unable to see the definition of the view under the SQL tab option.


Any help so that i can grant the required privilege to the user?
This post has been answered by sweetritz on Sep 1 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 30 2014
Added on Sep 1 2014
#general-database-discussions, #oracle
14 comments
7,072 views