Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.