USER_XS_PASSWORD_LIMITS

The USER_XS_PASSWORD_LIMITS data dictionary view describes the password limits for the currently logged on application user. The DBA can query this view to check the limits for any direct login user.

Column Datatype NULL Description
RESOURCE_NAME VARCHAR2(32) NOT NULL Name of the password resource
LIMIT VARCHAR2(128)   The limit placed on this resource