The following new columns are defined to support Last Login and Locking Inactive Accounts:
master..syslogins ( ..., lastlogindate datetime null, crdate datetime null, locksuid int null, lockreason int null, lockdate datetime null, ... )
These new columns are readable by public—the same permissions as most other columns in syslogins including pwdate, the date, the password last changed, and status, which includes bits to identify locked accounts and expired passwords. Only the password and audflags columns control select permission to system roles sso_role or sa_role.
