Category: Security
Database: DBC
View Column | Data Type | Format | Description |
---|---|---|---|
RoleName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of a role. |
Grantor | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The name of the user who granted the role. |
WhenGranted | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The date a role was granted. |
DefaultRole | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | Indicates whether a role is a default role for the grantee. If the grantee is a USER and has the role as default role, DefaultRole is 'Y'. Otherwise, the value is 'N'. |
WithAdmin | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Specifies 'Y' if Admin Option comes with the role grant; otherwise, the value is 'N'. |