This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
A gloved hand holds secateurs to one dead branch of a bare apple tree, pruned twigs on the snow below.

A Quarterly Permission Review

June 21, 2008
Pinal Dave
SQL Tips and Tricks
DBA, SQL Audit, SQL Login, SQL Server Security

A quarterly permission review checks server and database roles, new grants, orphaned users, service accounts, and owner signoff.

Read More
A barn with a high open hayloft door, one ladder in plain view and two more half hidden around the side.

Auditing Who Has sysadmin

January 16, 2008
Pinal Dave
SQL Tips and Tricks
DBA, SQL Audit, SQL Login, SQL Server Security

Audit who has sysadmin in SQL Server, including direct members and Windows groups, then investigate nested access and forgotten logins.

Read More
A stick insect hidden among twigs in a hedge, given away only by its thin red legs

Auditing Who Holds CONTROL SERVER and IMPERSONATE Rights

March 21, 2007
Pinal Dave
SQL Tips and Tricks
DBA, SQL Audit, SQL Login, SQL Server Security

Audit CONTROL SERVER and impersonation grants alongside sysadmin and role inheritance, test effective rights, and remove excess access.

Read More
Previous 1 2 3 4 5
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com