ROLES 
Definition
The system table ROLES describes the roles for which the current user has privileges.
Structure
ROLES
OWNER |
CHAR(32) |
Name of the owner of the role |
ROLE |
CHAR(32) |
Name of the role |
PASSWORD_REQUIRED |
CHAR(3) |
Password required for activating role (YES | NO) |
GRANTED |
CHAR(3) |
Role was granted to current user (YES | NO) |
DEFAULTROLE |
CHAR(3) |
Role is the default role for the current user (YES | NO) |
CREATEDATE |
DATE(10) |
Creation date of the role |
CREATETIME |
TIME(8) |
Creation time of the role |
See also:
Evaluating System Tables, ROLES
SQL Reference Manual, Role Name (role_name), Privileges: Overview