sp_displaylogin

Description

Displays information about a login account. Also displays information about the hierarchy tree above or below the login account when you so specify.

Syntax

sp_displaylogin [loginame [, expand_up | expand_down]]

Parameters

loginame

is the user login account about which you want information if it is other than your own. You must be a System Security Officer or System Administrator to get information about someone else’s login account.

expand_up

specifies that Adaptive Server display all roles in the role hierarchy that contain the loginame role.

expand_down

specifies that Adaptive Server display all roles in the role hierarchy that are contained by the loginame role.

Examples

Example 1

Displays information about your server login account:

sp_displaylogin
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)
Locked: NO
Date of Last Password Change: Nov 16 1994 10:08AM

Example 2

Displays information about the login account “susanne”. The information displayed varies, depending on the role of the user executing sp_displaylogin:

sp_displaylogin susanne
Suid: 12
Loginame: susanne
Fullname: 
Default Database: pubs2
Default Language: 
Auto Login Script:
Configured Authorization:
    supervisor (default OFF)
Locked: NO
Date of Last Password Change: May 12 1997 11:09AM 

Example 3

Displays information about all roles containing the role of the login account “pillai”. The information displayed varies, depending on the role of the user executing sp_displaylogin:

sp_displaylogin pillai, expand_up

Example 4

Displays the login security-related parameters configured for a login:

sp_displaylogin joe
Suid: 294
Loginame: joe
Fullname: Joseph Resu
Default Database: master
Default Language: 
Auto Login Script:
Configured Authorization: 
    intern_role (default OFF)
Locked: NO
Date of Last Password Change: Nov 24 1998 3:46PM
Password expiration interval : 5
Password expired : NO
Minimum password length:4
Maximum failed logins : 10
Current failed logins : 3

Usage

Permissions

Only a System Administrator or a System Security Officer can execute sp_displaylogin with the loginame and expand parameters to get information about other users’ login accounts. Any user can execute sp_displaylogin to get information about his or her own login account.

See also

Stored procedures sp_activeroles, sp_displayroles, sp_helprotect, sp_modifylogin