Logged in as scott:
Obviously, scott did not have the privilege to select from v$mystat. So, I went ahead and logged in as “sys as sysdba” and issued the following grant:
OOPS! What’s the problem here?!
Whenever I face a problem that I do not know how to solve, I always search for a solution first before starting to ask questions. So, a simple search for “ORA-02030″ on AskTom revealed that I needed to use v_$maystat instead of v$mystat:
Logged in as scott:
It worked. Now scott has access to v$mystat. So, if you want to grant a privilege on a v$ object, make sure you use the corresponding v_$ object.
Note that v$ objects are synonyms and v_$ objects are views:來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/10173379/viewspace-683351/，如需轉載，請注明出處，否則将追究法律責任。
轉載于:http://blog.itpub.net/10173379/viewspace-683351/