Database Administration (MOSC)

MOSC Banner

Question about Container and Pluggable settings - Profile

edited Aug 16, 2016 10:55AM in Database Administration (MOSC) 2 commentsAnswered ✓

I'm new to 12c container and pluggable settings so I'm trying to find out how it works.

I'm connected to the container and I have the following query;

select con_id, profile, RESOURCE_NAME,  LIMIT from cdb_profiles where RESOURCE_NAME='PASSWORD_LIFE_TIME'

    CON_ID PROFILE              RESOURCE_NAME                    LIMIT

---------- -------------------- -------------------------------- --------------------

         1 DEFAULT              PASSWORD_LIFE_TIME               UNLIMITED

         3 DEFAULT              PASSWORD_LIFE_TIME               180

Does this mean that local users in the pluggable database with con_id=3 will have their passwords expire in 180 days if I don't change it?

Or it will read the container setting?

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