how to use common user to select v$pdbs
dear all:
I create a common user ,below is my sql:
odba1>#sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sat Sep 30 09:55:01 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics
and Real Application Testing options
SYS@odba1> create user zz identified by zz;
User created.
SYS@odba1> grant connect to zz container=all;
Grant succeeded.
SYS@odba1> grant select any dictionary to zz container=all;
Grant succeeded.
SYS@odba1> show con_name
CON_NAME
------------------------------
CDB$ROOT
==============================
and then ,i want to this common user can select v$pdbs,but have issue below is: