Wednesday, March 6, 2013

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

I want to grant the user ability to select from v$session. so I issue the GRANT SELECT ON v$session TO rcs1; However, I got the ORA-02030: can only select from fixed tables/views

image

It turns out I have to grant the V$SESSION is just SYNONYM. when you query the dba_objects table, the object name must be UPPER CASE.

SELECT owner, object_type FROM dba_objects WHERE object_name = 'V$SESSION';

image

The actual table for the v$session is V$_session.

select table_owner, table_name FROM dba_synonyms where synonym_name = ‘V$SESSION’;

image

Lets try to grant the permission again.

GRANT SELECT ON V_$SESSION TO rsc1;

image

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates