Category: Security
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Name of the user to whom the logon rule applies. May be 'Default' to indicate all users. |
| LogicalHostID | SMALLINT NOT NULL | ZZZ9 | Unique identifier of the logon source for the logged query. A value of zero indicates an internal session. |
| LogonStatus | CHAR(1) LATIN NOT CASESPECIFIC NOT NULL | X(1) | Specifies the rule grants (G) or refuses (R) permission for the named user to log on from the identified client system. |
| NullPassword | CHAR(1) LATIN NOT CASESPECIFIC NOT NULL | X(1) | A code that specifies whether the rule allows this user to log on without a password from the specified client system. |
| CreatorName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | 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. |