1. dba 登陆
SQL> conn /as sysdba;
Connected.
2.切换session到PDB 容器
SQL> alter session set container=ORCLPDB;
Session altered.
没有这一步会碰到error:ORA-01917: user or role 'HR' does not exist
3.授权
SQL> grant select on v_$sesstat to hr;
Grant succeeded.
1. dba 登陆
SQL> conn /as sysdba;
Connected.
2.切换session到PDB 容器
SQL> alter session set container=ORCLPDB;
Session altered.
没有这一步会碰到error:ORA-01917: user or role 'HR' does not exist
3.授权
SQL> grant select on v_$sesstat to hr;
Grant succeeded.