THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Security » permissions   (RSS)
  • If you disable the guest user, please read this!

    As a matter of security, it is typically recommended to disable the guest user account across your user databases. For system databases, of course you have a tough time disabling guest access for tempdb and master, which are peripherally required for a lot of different types of activity. You have probably felt quite confident in disabling guest ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 29, 2011
  • Bad habits to kick : ignoring the principle of least privilege

    In my last post in this series, I talked about ''blind SQL Server installs'' and some of the potential consequences of making uninformed choices during setup (or of just accepting all of the defaults).  Today I wanted to touch on security a bit. I frequently see cases where we put too much trust where we shouldn't.  In the real world, ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 12, 2010
Privacy Statement