Category: Security
Database: DBC
View Column | Data Type | Format | Comment |
---|---|---|---|
DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns 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 UserRightsV.TableName field identifies a table, view, stored procedure or macro on which the user has an access right. |
ColumnName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the name of the column or parameter. |
AccessRight | CHAR(2) LATIN UPPERCASE NOT NULL | X(2) | Returns a code that identifies a privilege granted on the object. |
GrantAuthority | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Returns the WITH GRANT OPTION attribute of the access right held by the user. |
GrantorName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the grantor who granted the privilege. |
CreatorName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Table or database creator. For DBC.AllRights, the grantor of explicit rights, otherwise the user who executed the CREATE statement. |
CreateTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | Returns the date and time that the object in the row was created. |