ORA-02030: can only select from fixed tables/views
When we Grant the Select privilege on a V$ view we will get an ora-02030 error.
As ORA-02030 says, that we can only select from fixed tables/views, which means V$INSTANCE is not a table or view.
We know that actual view created on the dynamic performance table that is V_$. The V$ is only a synonym and not an actual fixed table or a view. Thus, When we try to grant select on the object we will receive the error: ORA-02030: can only select from fixed tables/views.
How to resolve ORA-02030–:
We need to replace V$ with V_$. It should be V_$INSTANCE. Because we can grant directly to the base table.
Because V$INSTANCE is a public synonym on view V_$INSTANCE.
These two queries will support my Solution. select OWNER, OBJECT_TYPE,OBJECT_NAME from dba_objects where object_name='V$INSTANCE'; select SYNONYM_NAME,TABLE_OWNER,TABLE_NAME from dba_synonyms where synonym_name='V$INSTANCE';
Please do the Like, Comments & Share in your circle.
With Best Wishes!!!!
Oracle Database Consultant
Certified in-: | 1XAzure | 6XOCI | 1XOCS (GG) | 1XOCE (RAC) | 3XOCP (11g,10g,9i) | 1XOCA (9i) |
My YouTube Channel (OracleRide)
Reference–: (Doc ID 1061103.6)–ORA-02030 WHEN GRANTING SELECT ON V$ VIEW
Guduru Venkata Sandeep Kumar · May 14, 2021 at 3:32 pm
Helpful Note, thanks for sharing this.