- 07 Dec, 2023
- 0 Comments
- 18 Secs Read
ORA-02030: Can Only Select From Fixed Tables/Views
Problem :
SQL> grant select on v$session to test; grant select on v$session to test * ERROR at line 1: ORA-02030: can only select from fixed tables/views
Solution :
You just need to replace v$ with v_$ i.e it should be v_$session.SQL> grant select on v_$session to test; Grant succeeded.