sys.sp_helplogins

Description

Provides information about logins and the users associated with them in each database. isn’t specified, information about all logins is The first report contains information about each login specified, as shown in the following

Syntax

sp_helplogins [ [ @
L ogin
N ame
P attern = ]
N
'LoginNamePattern'
]
[ ; ]

Examples

Example 1

sp_helplogins

Example 2

sp_helplogins

Example 3

sp_helplogins

Example 4

sp_helplogins

Example 5

John

Example 6

EXECUTE sp_helplogins
'John'
;
GO
LoginName SID DefDBName DefLangName AUser ARemote
--------- -------------------------- --------- ----------- ----- -------
John 0x23B348613497D11190C100C master us_english yes no
LoginName DBName UserName UserOrAlias
--------- ------ -------- -----------
John pubs John User