Tag Archives: database permissions

  1. The public role

    Leave a comment

    May 23, 2018 by Kenneth Fisher

    A common misunderstanding is that the CONNECT permission lets you do more than just connect to a database. It doesn’t. …
    Continue reading

  2. Who should own the database?

    6

    January 15, 2018 by Kenneth Fisher

    TL;DR; SA, or if you are really paranoid then you can create a disabled SQL login with minimal permissions and …
    Continue reading

  3. Simple Security Report

    2

    May 1, 2017 by Kenneth Fisher

    Quite a while ago I created a couple of little security scripts to help me out with permissions research. Over …
    Continue reading

  4. sp_SrvPermissions & sp_DBPermissions V6.0 Finally!

    5

    March 27, 2017 by Kenneth Fisher

    It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well, …
    Continue reading

  5. Write-Only permissions

    3

    August 11, 2016 by Kenneth Fisher

    Yep, that’s right, you heard me. Write-Only not Read-Only. I was presenting SQL Server Security Basics at NTSSUG the other …
    Continue reading

  6. The CONNECT permission

    6

    January 27, 2016 by Kenneth Fisher

    The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at …
    Continue reading

  7. Administrative Logins and Users

    1

    November 2, 2015 by Kenneth Fisher

    If you’ve ever worked through an audit you have probably gotten a request that looks a lot like this: Please …
    Continue reading

  8. Zombie AD Groups

    4

    September 21, 2015 by Kenneth Fisher

    I spent something like 2 hours today trying to figure out how a particular user had access to one of …
    Continue reading

  9. Permissions Posters

    3

    July 27, 2015 by Kenneth Fisher

    I’ve been doing a lot of research recently for my permissions session and for a project at work. During said …
    Continue reading

  10. Using sp_DBPermissions and sp_SrvPermissions v6.0

    1

    February 25, 2015 by Kenneth Fisher

    It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting. …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,180 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013