Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

12c : privileges required to create a pdb

Anju GargJul 19 2013 — edited Jul 23 2013

I am trying to craete a PDB as a non-sys user

CDB1>sho con_name

CON_NAME

------------------------------

CDB$ROOT

CDB1>select con_id, name, open_mode from v$pdbs;

    CON_ID NAME                                               OPEN_MODE

---------- -------------------------------------------------- ----------

         2 PDB$SEED                                           READ ONLY

         4 PDB3_COPY                                          READ ONLY

CDB1>create user c##sys identified by oracle;

User created.

CDB1>grant connect, resource to c##sys;

Grant succeeded.

CDB1>grant create pluggable database to c##sys;

CDB1>grant dba to c##sys;



CDB1>conn c##sys/oracle@cdb1

Connected.

CDB1>sho user

USER is "C##SYS"

CDB1>create pluggable database pdb1 from pdb3_copy;

create pluggable database pdb1 from pdb3_copy

*

ERROR at line 1:

ORA-01031: insufficient privileges

What all minimum privileges are required to create a PDB?

Regards

This post has been answered by unknown-7404 on Jul 22 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 20 2013
Added on Jul 19 2013
6 comments
4,668 views