How to authorize query v $ View

How to authorize query of views starting with v $ in non-sys and system User stored procedures, such as v $ mystat and v $ statname. These View queries can be used in stored procedures only after authorization is displayed under sys. However, if we use grant on v $ view to username, we will receive a ORA-02030 error. SQL> grant select on v $ mystat to scott; grant select on v $ mystat to scott www.2cto.com ORA-02030: you can only query from a fixed table or view. This is because v $ mystat is not a view and is actually a synonym. Therefore, you must authorize the view corresponding to the synonym. SQL> grant select on v _ $ mystat to scott; Grant succeeded tips. You can also try it.