USER_PASSWORD_LIMITS

Oracle 11gR1

USER_PASSWORD_LIMITS describes the password profile parameters that are assigned to the user.

Column	Datatype	NULL	Description
RESOURCE_NAME	VARCHAR2(32)	NOT NULL	Name of the password resource
LIMIT	VARCHAR2(40)		Value of the resource limit

Note:

1.

select * from USER_PASSWORD_LIMITS;

RESOURCE_NAME	LIMIT
FAILED_LOGIN_ATTEMPTS	50
PASSWORD_LIFE_TIME	UNLIMITED
PASSWORD_REUSE_TIME	UNLIMITED
PASSWORD_REUSE_MAX	UNLIMITED
PASSWORD_VERIFY_FUNCTION	NULL
PASSWORD_LOCK_TIME	UNLIMITED
PASSWORD_GRACE_TIME	UNLIMITED

Oracle data dictionary views