SQL Scripts: List Databases A Login Can Access
When you are managing your SQL Server database permissions through Active Directory Groups (which you should be!), it can sometimes be difficult to know just which databases a user actually …
Notes From A SQL 2017 Azure Install – Using Group Managed Service Accounts
One of the new features that I’m excited about implementing on my Windows 2016 SQL Server 2017 servers is the ability to use Group Managed Service Accounts, or “gMSA” for short. …
SQL Scripts: How To Change The Owner Of A Database
Sometimes it becomes necessary to change the owner of a database. When a database is first created, SQL Server likes to set the owner of that database to the login …
SQL Scripts: How To Check Logins And Permissions
Security and permissions are a big part of a DBA’s job, and being able to find out things such as who has elevated login permissions, or when the last time …
Stored Procedures Ignore User’s Permissions
So, that title may be a little misleading to some. It is not meant as a blanket statement about all procedures and all permissions, but rather a specific situation that …