Simon Facer

  • Interests: My kids, building furniture, DIY, garden ponds, SQL Server and PDW

Technical Article

Audit SQL Logins

We have auditors in the building, looking at our security (amongst other things). So, we needed an easy way to generate a listing of the SQL logins, and the permissions into each database on our servers (over 70 if them).This script will generate the listings the auditors wanted.

5 (9)

You rated this post out of 5. Change rating

2007-04-02 (first published: )

5,608 reads

Blogs

Parameter Sensitive Plan Optimization in SQL Server 2022. What is it and is it any good?

By

Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...

Azure chaos STUDIO

By

Chaos engineering is fun but especially important when building solutions in the cloud. It...

Announcing a New Book on SQL from 3Cloud Authors

By

I am proud to announce the launch of a new book, centered around the...

Read the latest Blogs

Forums

Where to buy Errli Gummi Sharks online | Aussie THC Edibles

By aussiethcedibles

Are you looking to buy Errli Gummi Sharks online? Explore our website www.aussiethcedibles.com to...

Delayed tcp acknowledgement registry setting

By Rasmus Remmer Bielidt

Our IT department contacted me recently and asked if they should change the default...

Fact Table - Various Grains

By flamblaster

Hi there, I'm on a team developing an enterprise data warehouse for our organization....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers