ROLES 
This system table describes the roles for which the current user has privileges.
ROLES
|
OWNER |
CHAR(32) |
Name of role owner |
|
ROLE |
CHAR(32) |
Name of role |
|
PASSWORD_REQUIRED |
CHAR(3) |
Password required for activating the role (YES/NO) |
|
GRANTED |
CHAR(3) |
Role was granted for the 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 |
|
CREATETIM |
TIME(8) |
Creation time of the role |
See also:
Evaluating System Tables ® ROLES