Category: Security
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of a database or one of the special system keywords: ALL / DEFAULT / PUBLIC. |
| TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of a table, view, stored procedure, trigger, macro, or user. |
| ColumnName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The table column or the view column which a right has been granted. |
| Grantee | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of a user who was granted a privilege; ALL can be specified. The name of a user or role who was granted a role. |
| AccessRight | CHAR(2) LATIN UPPERCASE NOT NULL | X(2) | A code that identifies a privilege granted on the object. |
| GrantAuthority | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | The WITH GRANT OPTION attribute of the access right held by the user. |
| AllnessFlag | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Specifies Y (yes) or N (no) to indicate whether the privilege was granted to all subordinate users, or to all users who are owned by the grantee. |
| CreatorName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Table or database creator. For DBC.AllRights, the grantor of explicit rights, otherwise the user who ran the CREATE statement. |
| CreateTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The date and time that the object in the row was created. |