Thursday, April 24, 2008

Grant on v$ views

Have you faced similar problem while providing Grant on v$ views

SQL> grant select on v$session to scott;
grant select on v$session to scott
*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views


Reason:

Oracle v$ views are named V_$VIEWNAME and they have synonyms in format V$VIEWNAME and you can’t give privilage on a synonym.

If you want to give permission to a V$ view you must give it like below

SQL> grant select on v_$session to scott;

Grant succeeded.




No comments: