ORA-02030: Can Only Select From Fixed Tables/Views

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarANKUSH THAVALI
  • 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.

Hope it Helps!