A technical troubleshooting blog about Oracle with other Databases & Cloud Technologies.

Common user password change:

1 min read
door handle key keyhole

Photo by Pixabay on Pexels.com

Common user password we can change from only cdb level .container class is optional.

CDB container:
====================================

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> alter user C##USERTEST identified by test container=all;

User altered.

SQL> alter user C##USERTEST identified by test;

User altered.




PDB level:
====================================

SQL> show con_name

CON_NAME
------------------------------
DEV18
SQL>
SQL> alter user C##USERTEST identified by test;
alter user C##USERTEST identified by test
*
ERROR at line 1:
ORA-65066: The specified changes must apply to all containers


SQL> alter user C##USERTEST identified by test container=all;
alter user C##USERTEST identified by test container=all
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database


SQL> alter user C##USERTEST identified by test container=current;
alter user C##USERTEST identified by test container=current
*
ERROR at line 1:
ORA-65066: The specified changes must apply to all containers