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!

Cannot Select Data Dictionary Views or Tables

RijuNov 10 2013 — edited Nov 12 2013

Hi,

I have a normal user from which I want to view the data dictionary tables and views like DBA_ and V$_ since I do not want to log in to the SYS account everytime.

I have granted all privileges to the user but it is not working. These are the commands that I have used.

grant all privileges to user;

grant sysdba to user;

Can you please help me

This post has been answered by Nikolay Savvinov on Nov 10 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 10 2013

Added on Nov 10 2013

#general-database-discussions

6 comments

639 views