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