THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Security » permissions   (RSS)
  • Administering SSIS: Security-related SSIS Questions

    I credit my friend and brother, Chris Yates (Blog | @YatesSQL), for inspiring me to write this post with his (excellent) post: Reports in SSIS. If I had a nickel for each time I’ve been asked, “What permissions are required for SSIS?” I would have a lot of nickels. It’s a fair question with an unfair answer, “It depends.” “It Depends on ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 19, 2015
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement