6 Replies Latest reply: Jul 23, 2013 10:17 AM by ManojNair RSS

    ALTER SESSION SET CONTAINER can only be executed as sysdba ?

    Orna Weisman

          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 ?