Hi
I createded a common user c##oracle ( identified externally.
Igranted it dba,cdb_dba,set container - but still I cannot set the container to my pluggable database using that user :
sqlplus /
SQL*Plus: Release 12.1.0.1.0 Production on Fri Jul 19 15:03:21 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Last Successful login time: Fri Jul 19 2013 14:58:54 +00:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> ALTER SESSION SET CONTAINER = CDB$ROOT;
Session altered.
SQL> alter session set container=edwt;
ERROR:
ORA-01031: insufficient privileges
only a sysdba it works :
sqlplus "/as sysdba"
SQL*Plus: Release 12.1.0.1.0 Production on Fri Jul 19 15:11:03 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> alter session set container=edwt;
Session altered.
SQL>
What privilege do I need to give my common user so I can set hte container to a pluggable database ?