SQL> create user pyb1 identified by pyb1pyb1;

grant connect,resource to pyb1;

使用 pyb1 登录系统

SQL> select * from v$mystat;
select * from v$mystat
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select * from v$session;
select * from v$session
              *
ERROR at line 1:
ORA-00942: table or view does not exist

授权(即时生效)

grant select on v_$mystat to pyb1;
grant select on v_$session to pyb1;

或者授权(需要重新登录)

grant select_catalog_role to pyb1;

感觉 select_catalog_role 权限有点过大

https://docs.oracle.com/en/database/oracle/oracle-database/21/dbseg/configuring-privilege-and-role-authorization.html#GUID-F4BE7D94-B60E-42CE-9AFA-2D0C0443C31F