OracleDB‎ > ‎

V Dollar

Oracle Grant on V Dollar views

SQL> conn / as sysdba Connected. SQL> grant select on v$session to XYZ; grant select on v$session to XYZ ERROR at line 1: ORA-02030: can only select from fixed tables/views

Here is the correct syntax

GRANT SELECT ON v_$session TO xyz;


Comments