Database Administration (MOSC)

MOSC Banner

Profile for common users in PDB

edited Jun 7, 2022 8:38AM in Database Administration (MOSC) 4 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center