Mapping logins using sp_maplogin  New global variable @@authmech

Chapter 7: Security Changes

sp_helpmaplogin

sp_helpmaplogin displays mapping information. With no parameters, all login map information displays. You can restrict the output to specific sets of client user names or authentication mechanists by using:

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

For example, issuing sp_helpmaplogin returns something that looks similar to:

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





Copyright © 2004. Sybase Inc. All rights reserved. New global variable @@authmech

View this book as PDF