The DBA_PROFILES view provides the information about existing profiles. The table includes a row for each profile or resource combination.

Parameter Type Description
profile CHARACTER VARYING(128) The name of the profile.
resource_name CHARACTER VARYING(32) The name of the resource associated with the profile.
resource_type CHARACTER VARYING(8) The type of resource managed by the profile; currently PASSWORD for all supported resources.
limit CHARACTER VARYING(128) The limit values of the resource.
common CHARACTER VARYING(3)
  • YES: indicates that the profile is a user-created profile.
  • NO: indicates that the profile is a system-defined profile.