ORA-01031: insufficient privileges ALTER PLUGGABLE DATABASE to OPEN I'm currently working with Oracle database version 12c. I have created a common admin user - "C##ADMIN" with DBA Role. But when trying to execute the following script: 

ALTER PLUGGABLE DATABASE TESTPDB OPEN;


I hit error:


  ORA-00990: missing or invalid privilege


How should I assign the correct roles/privileges to "C##ADMIN" in order to run script above?
Just grant SYSDBA/DBA privilege to the user to all containers and login as SYSDBA to perform the task.

Demo:

SQL&gt; create user c##admin identified by c##admin container=all;

User created.

SQL&gt; grant sysdba to c##admin container=all;

Grant succeeded.

SQL&gt; conn c##admin as sysdba
Enter password:
Connected.
SQL&gt; alter pluggable database orclpdb open;