Question Apologies in advance if I don’t use some terminology correctly here. I’m not a DBA but I’ve been temporarily forced into the role. I’ve inherited an application that runs on SQL Server 2016 Enterprise – one instance for PROD and another for TEST. These … [Read More]
Question A couple years ago we ran into a situation where we were changing the database owner from a DBA’s login to sa, and immediately thereafter we received a complaint that the service login (which was NOT the DBA’s login) no longer had access to … [Read More]
Microsoft docs defines the dbcreator role as: Members of the dbcreator fixed server role can create, alter, drop, and restore any database. But what specific permissions are actually included in that role? If we scroll down in the docs just a little, we’ll see a … [Read More]
As a DBA or SQL Developer, you’ve surely encountered a scenario where something worked for you, but not for another user. DBAs usually are part of the sysadmin role, or have a collection of powerful permissions. If I run code as myself, I will never … [Read More]
Copyright © 2024 | Andy Mallon | am2.co