Database Administration (MOSC)

MOSC Banner

Why ORDS_METADATA user does not have expiry date

in Database Administration (MOSC) 2 commentsAnswered

I noticed that the user ORDS_METADATA does not have. I know this user it comes with ORDS which we are using, but why no expiry date?

SQL> SELECT username, profile, account_status, expiry_date FROM dba_users WHERE username = 'ORDS_METADATA';

USERNAME PROFILE ACCOUNT_STATUS EXPIRY_DATE
—————- ———— ————————— ——————
ORDS_METADATA DEFAULT OPEN

SQL> SELECT limit FROM dba_profiles WHERE profile = 'DEFAULT' and resource_name='PASSWORD_LIFE_TIME';

LIMIT
——-
184

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