Get the App
SLTechnology News&Howtos  ›  Database  › 

Oracle 12c create user container parameters

Shulou Source: shulou.com Published: 2022-06-01 03:47:27 11月17日 Update

The default for creating users under cdb is container=all, and container=current cannot be set.

The default for creating users under pdb is container=current, and container=all cannot be set.

1. Create a user with the container parameter under pdb:

SQL > show con_name

CON_NAME

-

TEST

SQL > create user scott identified by tiger container=all

Create user scott identified by tiger container=all

*

ERROR at line 1:

ORA-65050: Common DDLs only allowed in CDB$ROOT

SQL > create user scott identified by user container=current

User created.

SQL > show con_name

CON_NAME

-

TEST

two。 Create parameters under cdb user

SQL > show con_name

CON_NAME

-

CDB$ROOT

SQL > create user d identified by d

Create user d identified by d

*

ERROR at line 1:

ORA-65096: invalid common user or role name

SQL > create user cantilever identified by d container=current

Create user c##d identified by d container=current

*

ERROR at line 1:

ORA-65094: invalid local user or role name

SQL > create user cantilever identified by d container=all

User created.

SQL > show con_name

CON_NAME

-

CDB$ROOT

Tags: User parameter Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno NVidia OPPO Reno Shulou Information MySQL MariaDB