Category: Accounting
Database: DBC
View Column | Data Type | Format | Description |
---|---|---|---|
UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of a user to whom the privilege was granted. |
DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of the database on which a privilege was granted. The possible values are: ALL/PUBLIC. |
TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of a table, view, stored procedure, trigger, macro, user-defined types, user-defined methods, or user-defined function on which a privilege was granted. |
ColumnName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The column name to which a privilege has been granted. |
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. |
GrantorName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The name of the grantor who granted the privilege. |
AllnessFlag | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Indicates whether the privilege was granted to all subordinate users (Y (yes) or N (no)), 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. |