Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

sql server 2008 permissions

does anyone have any useful query to list all logins in a 2008 instance, and their permissions, i.e. which roles they are assigned, with databases they have access to etc, and their status (i.e. enabled/disabled)? I need this for all users not just one.
0
pma111
Asked:
pma111
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I think this article should give you all you are requesting:
http://gallery.technet.microsoft.com/scriptcenter/Get-logins-databases-816f66b2
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now