Skip to content
July 22, 2011 / doganay

HOW TO GRANT ON V$ VIEWS (ORA-02030: CAN ONLY SELECT FROM FIXED TABLES/VIEWS)

 
Hi,

How to grant on v$ views

If you try to grant on v$views to a user or role, you get ORA-02030 error.

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

This is because you try to grant on a synonym. You have to grant on the real object:

SQL> grant select on V_$SQL to muyser;
Grant succeeded.

Try and pray :)
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: