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?