Password Expiration handled

[rguillen]

How can I know how many days I have left before the password expires?

Thanks for your help.

 

[Marco Kalter]

The user_users view contains the following columns:

ACCOUNT_STATUS (The Account Status, for example OPEN, LOCKED, and so on)

LOCK_DATE (Date the account was locked if account status was LOCKED)

EXPIRY_DATE (Date of expiration of the account)

See the Oracle9i Database Reference for more details.

------------------
Marco Kalter
Allround Automations

 

[rguillen]

Thanks for your help.