Purpose
The DBA_ROLES view displays all the roles in the database.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| ROLE | VARCHAR2(30) | NO | The name of the role. |
| PASSWORD_REQUIRED | VARCHAR2(8) | NO | Indicates whether the role requires a password to be enabled. The role password feature is supported but this column cannot be correctly displayed. |
| AUTHENTICATION_TYPE | VARCHAR2(11) | NO | Indicates the identity authentication mechanism of the role. This column is not supported at present. |
