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

SYS.DBA_PROFILES

The DBA_PROFILES view describes all the profiles in the database and the values of the password parameters for each of the profiles.

Related views

There is neither a SYS.ALL_PROFILES nor a SYS.USER_PROFILES system view. See SYS.USER_PASSWORD_LIMITS for information on the password profile parameters that are assigned to a particular user.

Columns

Column name Type Description

PROFILE

VARCHAR2(30) INLINE NOT NULL

Profile name.

RESOURCE_NAME

VARCHAR2(32) INLINE NOT NULL

Name of the password parameter. For example, FAILED_LOGIN_ATTEMPTS.

RESOURCE_TYPE

VARCHAR2(8) INLINE NOT NULL

Type of resource. Valid value: PASSWORD.

LIMIT

VARCHAR2(40) INLINE

Value of the password parameter.