Error 15434: could not drop login ‘test’ because the user is logged in. A reader ran my demo on production; here is my Force Removing User fix, no restart needed.
SQL SERVER – Disable Guest Account – Serious Security Issue
I like to disable guest account access in SQL Server unless there is a real need for it. Here is why the guest user can be a serious security issue.
SQL SERVER – Case Sensitive Database and Database User – Fix: Error: 15151 – Cannot find the user , because it does not exist or you do not have permission.
Jeff hit Error 15151, cannot find the user, even though the user existed. The cause was a case sensitive database, and here is the fix.
Counting Users, Roles and Orphans in Every Database
Audit counting users across databases, include roles and schema ownership, and distinguish orphaned SQL users from contained identities.
SQL SERVER – 2012 Auditing Enhancement – On Audit Log Failure Options – Maximum Rollover Files
SQL Server 2012 adds two auditing enhancements: new options on audit log failure, like fail operation or continue, and a maximum rollover files setting.
Certificate-Signed Procedures That Read Server DMVs Safely
Give a developer lock-wait data without handing over a server-wide permission. A signed procedure carries the authority, and an edit takes it away.
EXECUTE AS OWNER in Stored Procedures: Power and Pitfalls
A procedure with owner rights can write to tables its caller cannot touch. Watch the identity change, and see how one careless parameter hands out too much.