-1

How long expired(grace) status will exist before the actual expiration of user in Oracle? How to find the actual expiry date when a user is in expired(grace) status?

I have tried using dba_users table but in the table expiry date is null for users having expired(grace)

Ananthu rajeev
  • 21
  • 3

1 Answers1

0

The grace period is set from the point of the last login that cross the threshold of expiry.

So you should be able to add the grace period length to DBA_USERS.LAST_LOGIN to find the theoretical expiry date.

Connor McDonald
  • 10,418
  • 1
  • 11
  • 16