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,609 reads

Blogs

Polyglot Persistence

By

I’ve seen the term polyglot persistence floating around Redgate a bit recently in the...

Six Months!

By

Oh good gosh. Six months without a single blog post. Most important information: I’m...

Speaking at dataMinds Connect 2024

By

I’m very excited to announce I’ve been selected as a speaker for dataMinds Connect...

Read the latest Blogs

Forums

Have you seen this in the news today?

By skeleton567

You might want to look into this issue: Windows flaw lets hackers sneak into...

how to find the cpu memory disk and network of the OS where RDS is residing.

By rajemessage 14195

hi, i have one RDS, but i do not have any other permissions, and...

“user_scans” of table “sys.dm_db_index_usage_stats”

By Meera

I am trying to find answer to the below. What exactly the scan means...

Visit the forum

Question of the Day

A Lack of Memory Grant Feedback Persistence

SQL Server has added an Intelligent Query Processing feature called Memory Grant Feedback. In SQL Server 2022, this can be persisted across queries to improve the performance of future executions. In SQL Server 2022, when is memory grant feedback not persisted if the plan is evicted from cache? (choose 2)

See possible answers