Displaying password information

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

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

This example displays information about the login joe which is bound to a login profile:

sp_displaylogin joe

Suid: 3
Loginame: joe
Fullname: Joe Williams
Configured Authorization: 
      sa_role (default ON)
      sso_role (default ON)
      oper_role (default ON)
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 Profile: emp_lp

This example displays information about the login joe which is not bound to a login profile:

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 Reference Manual: Procedures.

1. Use sp_displayroles to display the login and 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 Reference Manual: Procedures.