DBA_PROFILES v16
The DBA_PROFILES view provides information about existing profiles. The table includes a row for each profile/resource combination.
| Name | Type | Description |
|---|---|---|
profile | CHARACTER VARYING(128) | Name of the profile. |
resource_name | CHARACTER VARYING(32) | Name of the resource associated with the profile. |
resource_type | CHARACTER VARYING(8) | Type of resource governed by the profile. PASSWORD for all supported resources. |
limit | CHARACTER VARYING(128) | The limit values of the resource. |
common | CHARACTER VARYING(3) | YES for a user-created profile, NO for a system-defined profile. |