Tuesday, 19 June 2018

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

I'm granting SELECT privilege to SCOTT schema , however we faced following issue.

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




Fix:

Error is trying to say that , we can give "Select "  privilege only on tables/views.

So lets check here.


We can see here its Synonym, lets find out base table for this Synonym.



Original table name is "V_$PARAMETER" So lets give permission on same.




No comments:

Post a Comment