Chirag, Grant Select_catlog_role to that user. Nisar Tareen Chirag DBA <ChiragDBA@xxxxxxxxx> wrote: Hi Friends..!! How to grant select to a user on DBA_ and V$ views? Grant Select any table to USER1; will do that? or I need to give select any catalogue role? --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/dba_gurus/ To unsubscribe from this group, send an email to: dba_gurus-unsubscribe@xxxxxxxxxxxxxxx Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term'