Lisr DB users and permissions (also through roles)

• mtz676

  SSCrazy Eights

  Points: 9237

  More actions

  April 28, 2015 at 11:21 am

  #300206

  Which tables should I query to capture all the Logins on a sql server along with their permission levels.

  Thanks

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737004

  More actions

  April 28, 2015 at 2:11 pm

  #1794108

  Server or database level?

  here are a few items:

  http://www.sqlservercentral.com/scripts/Security/62064/

  http://www.sqlservercentral.com/scripts/Security/66129/