Request for script list of logins and the users?

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  November 26, 2013 at 5:08 am

  #280500

  Hi,

  I want script for getting command existing user, login and their permmission etc..

  there any built-in stored proc that can list the logins and the users with their permission level?

  thanks

  ananda

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  November 26, 2013 at 5:50 am

  #1669102

  ananda.murugesan (11/26/2013)

  ---

  Hi,

  I want script for getting command existing user, login and their permmission etc..

  there any built-in stored proc that can list the logins and the users with their permission level?

  thanks

  ananda

  You can use the sp_helplogins procedure. It takes an optional parameter for a login to match against.

  http://technet.microsoft.com/en-us/library/ms190304%28v=sql.100%29.aspx

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions