Category: Security
Database: DBC
View Column | Data Type | Format | Comment |
---|---|---|---|
UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The LogonRulesV.UserName field shows the name of the user to whom the logon rule applies. May be 'Default' to indicate all users. |
LogicalHostID | SMALLINT NOT NULL | ZZZ9 | Returns a 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) | Returns if 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) | Returns 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 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. |