Tag Archives: security

  1. Impersonating a server level permission

    2

    February 26, 2014 by Kenneth Fisher

    Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s …
    Continue reading

  2. sp_SrvPermissions & sp_DBPermissions V4.0

    Leave a comment

    January 15, 2014 by Kenneth Fisher

    These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data …
    Continue reading

  3. sp_SrvPermissions & sp_DBPermissions V3.0

    Leave a comment

    November 4, 2013 by Kenneth Fisher

    These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data …
    Continue reading

  4. I’ve refreshed a test database from prod but now the users can’t access it.

    3

    October 9, 2013 by Kenneth Fisher

    This happens to me all the time. I get a request from a developer to overwrite the test copy of …
    Continue reading

  5. sp_DBPermissions V2.0

    1

    September 18, 2013 by Kenneth Fisher

    Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The …
    Continue reading

  6. sp_SrvPermissions V2.0

    1

    September 18, 2013 by Kenneth Fisher

    Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The …
    Continue reading

  7. How do the fixed Database and Server roles map to more specific permissions?

    Leave a comment

    September 9, 2013 by Kenneth Fisher

    I recently asked what the difference is between granting SELECT to a user (at a database level) and adding the …
    Continue reading

  8. sp_SrvPermissions

    Leave a comment

    August 19, 2013 by Kenneth Fisher

    Last week I posted my stored procedure for database permissions, sp_DBPermissions. A couple of days later I was demonstrating it …
    Continue reading

  9. sp_DBPermissions

    3

    August 14, 2013 by Kenneth Fisher

    Last week I posted a series of database permissions scripts. I’ve been using them quite a bit over the last …
    Continue reading

  10. Database Permissions Queries

    Leave a comment

    August 5, 2013 by Kenneth Fisher

    Over the last year of blogging my thoughts and queries I’ve discovered something interesting. I posted Where is my Backup? …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 163 other followers