Database Administration (MOSC)

MOSC Banner

how to use common user to select v$pdbs

edited Oct 16, 2017 5:03AM in Database Administration (MOSC) 1 commentAnswered

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center