sp_displaylogin includes these changes:
supports both a wildcard expression and a server user ID, and displays matching logins:
sp_displaylogin ['user_id' | '[loginame | wildcard]'
user_id – user ID (suid) of the user whose login you are displaying.
wildcard – wildcard character used for search purposes.
Displays the login account for the user with a suid of 56:
sp_displaylogin '56'
Displays the login account information for all users whose logins begin with “st”:
sp_displaylogin 'st%'
sp_displaylogin displays the encryption versions used for a login. For example, the last line of this output includes information about the login encryption Adaptive Server uses:
Suid: 1 Loginame: sa Fullname: Default Database: master Default Language: Auto Login Script: Configured Authorization: sa_role (default ON) sso_role (default ON) oper_role (default ON) sybase_ts_role (default ON) Locked: NO Date of Last Password Change: Mar 8 2007 3:04PM Password expiration interval: 0 Password expired: NO Minimum password length: 6 Maximum failed logins: 0 Current failed login attempts: Authenticate with: ANY Login Password Encryption: SHA-256
If Adaptive Server uses encryption algorithms from earlier and the current release during a downgrade period, sp_displaylogin displays the earlier Sybase proprietary encryption algorithm and the new algorithm, SHA-256:
Login password encryption: SYB-PROP, SHA-256
When a login has been locked, sp_displaylogin shows the date, reason, and login that locked the account. For more information on sp_displaylogin, see Chapter 10, “Supported Security Features” for more information.