Mapping logins using sp_maplogin  Determining the authentication mechanism

Chapter 16: External Authentication

Displaying mapping information

sp_helpmaplogin displays mapping information:

sp_helpmaplogin [ (authentication_mech | null), (client_username | null) ] 

Where authentication_mech is one of the valid values specified for authenticate with option in sp_modifylogin, and client_username is is an external user name.

If you do not include any parameters, sp_helpmaplogin displays login information about all users currently logged in to Adaptive Server. You can restrict the output to specific sets of client user names or authentication mechanists by using the parameters listed above.

This displays information about all logins:

sp_helpmaplogin
authentication   client name   login name
--------------   -----------   ------------------
NULL             jsmith        guest
LDAP             NULL           create login




Copyright © 2005. Sybase Inc. All rights reserved. Determining the authentication mechanism

View this book as PDF