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!

Create common user with "container=all" option

Larry LiangNov 20 2023

Hello colleagues,

Wonder if any of you have come across the actual meaning of the option “container=all” in creating a common user in CDB.

Is there another option except “container=all”? If we don't specify it, it defaults to “ALL” anyway, and we cannot specify “container=pdb1, pdb2, …” , and it really does not mean anything. Any comment on this?

If we have 10 PDBs, and we would like to create a common user in 8 of them and don't want it to be created in other two, is there an option to specify containers in CDB?

Larry

Comments
Post Details
Added on Nov 20 2023
2 comments
3,649 views