Displaying password information

This section discusses how to display password information for logins and roles.

1. Use sp_displaylogin to display the password settings for a login.

   This example displays information about the login joe:

   sp_displaylogin joe
   

   Suid: 3
   Loginame: joe
   Fullname:
   Default Database: master
   Default Language:
   Auto Login Script:
   Configured Authorization:
   Locked: NO
   Date of Last Password Change: Sep 22 2008  3:50PM
   Password expiration interval: 0
   Password expired: NO
   Minimum password length: 6
   Maximum failed logins: 1
   Current failed login attempts: 2
   Authenticate with: ANY
   Login Password Encryption: SHA-256
   Last login date: Sep 18 2008 10:48PM
   

   See sp_displaylogin in the Reference Manual: Procedures.

1. Use sp_displayroles to display the password settings for a role.

   This example displays information about the physician_role role:

   sp_displayroles physician_role, "display_info"
   

   Role name = physician_role
   Locked : NO
   Date of Last Password Change : Nov 24 1997  3:35PM
   Password expiration interval = 5
   Password expired : NO
   Minimum password length = 4
   Maximum failed logins = 10
   Current failed logins = 3
   

   See sp_displayroles in the Reference Manual: Procedures.