Contents tagged with Security
-
Who Owns Your Databases?
Right now we have owners set to whoever creates the databases for most databases, but there are a few owned by sa. I'm thinking how great it would be to consolidate this. To this end, I've created a database owner domain account and added it as a SQL server login. The login only has the public server role. In a move common with things I typically do, going overboard, I have denied this accounts ability to connect to the server and disabled it.