SYSCAT.ROLES catalog view
Each row represents a role.
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| ROLENAME | VARCHAR (128) | Name of the role. | |
| ROLEID | INTEGER | Identifier for the role. | |
| CREATE_TIME | TIMESTAMP | Time when the role was created. | |
| AUDITPOLICYID | INTEGER | Y | Identifier for the audit policy. |
| AUDITPOLICYNAME | VARCHAR (128) | Y | Name of the audit policy. |
| AUDITEXCEPTIONENABLED | CHAR (1) | Reserved for future use. | |
| REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |