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)

2007-04-02 (first published: )

5,584 reads

Blogs

Storage Field Day 23 – SIOS

By

I am thrilled to have been a part of this year’s Storage Field Day...

Getting a list of the articles in a publication.

By

The other day I was asked to supply a list of all of the...

Daily Coping 17 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SSRS permissions basics

By cb122

Is it possible via a query, specific to 'SSRS' (SQL Server Reporting Services) to...

Azure SQL Database Differential Backup Frequency

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Azure SQL Database Differential Backup...

The General Database Platform

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The General Database Platform

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers