Profile for common users in PDB
Hi,
by design I can not change a password for a common user in a PDB (ORA-65066: The specified changes must apply to all containers ). This is expected.
For my interest I try the following testcase:
I create a password profile in a PDB with a shorter PASSWORD_LIFE_TIME then default and apply this profile to the common user (doing this all in a PDB)
create profile passwd_change limit PASSWORD_LIFE_TIME 2;
alter user c##test profile passwd_change;
My question: Why is that possible? If the password expires due former assigned profile I can not change it at PDB Level (ORA-65066) So it makes no sense and should not be possible to create a password profile in a PDB and assign it to a common user in a PDB when I‘m not be able to change the password on PDB level.