Skip to content
August 9, 2012 / doganay

ORA-02030: can only select from fixed tables/views


Problem:

SQL> grant select on v$sql to myuser;

grant select on v$sql to myuser
*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views


Cause:

You try to grant on a synonym. You have to grant on the real object.


Solution:

SQL> grant select on v_sql to muyser;
Grant succeeded.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: