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