Home » permissions
Auditing Linked Server Security: Who Connects as Whom
· by Hannah Vernon · in security
A linked server login mapping can let every login run as one remote login. Tests on SQL Server 2025 and an audit query to find the risky mappings.
Cross-Database Ownership Chaining: What a db_owner Can Reach
· by Hannah Vernon · in security
How cross-database ownership chaining works, a test on SQL Server 2019 and 2025 of what a db_owner can read with it, and a query to find it.
Testing Trace Flag 2861 and Zero-Cost Plans on SQL Server 2019 and 2025
· by Hannah Vernon · in performance
Does SolarWinds DPA’s trace flag 2861 keep zero-cost plans in the plan cache? A test on SQL Server 2019 and 2025 found no measurable effect.
Logins, SIDs, and Kerberos from First Principles, Part 4: Scripting Every Permission a Principal Holds
· by Hannah Vernon · in configuration, security
moved logins between servers with their SIDs and passwords intact. That gets a principal through the front door; it says nothing about what the principal can do once inside. Permissions live in a different set…