Common user password change:
1 min readCommon 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
