1. System Tables and Views Reference
  2. System Tables and Views 
  3. SYS.USER_PASSWORD_LIMITS

SYS.USER_PASSWORD_LIMITS

The USER_PASSWORD_LIMITS view describes the password profile parameters for the user who is currently connected to the database.

Related views

There is neither a SYS.ALL_PASSWORD_LIMITS nor a SYS.DBA_PASSWORD_LIMITS system view. See SYS.DBA_PROFILES for information on the profiles in the database.

Columns

Column name Type Description

RESOURCE_NAME

VARCHAR2(32) INLINE NOT NULL

Name of the password parameter. For example, FAILED_LOGIN_ATTEMPTS.

LIMIT

VARCHAR2(40) INLINE

Value of the password parameter.