Attention: We are retiring the ASP.NET Community Blogs. Learn more >

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.