Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How can I list users whose password will expire soon ?

Ken_73Jun 19 2014 — edited Jun 19 2014

DB version:11.2

Platform: Oracle Linux 6.3

The below mentioned user manhadm's password will expire in 14 days. ie it is under grace period ( PASSWORD_GRACE_TIME 14 ). He can still login though.

$ sqlplus manhadm/prtSmb23

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jun 19 16:30:49 2014

ERROR:

ORA-28002: the password will expire within 14 days

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL>

Is there a way I can find all the DB users whose password will expire soon ?

This post has been answered by Dom Brooks on Jun 19 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 17 2014

Added on Jun 19 2014

#general-database-discussions

3 comments

9,546 views