Tag Archives: security

  1. Add them to ALL the roles!

    3

    July 21, 2014 by Kenneth Fisher

    I seem to get a lot of permissions questions these days and one of the more frequent ones goes along …
    Continue reading

  2. db_ddladmin and the SSMS table designer

    Leave a comment

    July 10, 2014 by Kenneth Fisher

    If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you …
    Continue reading

  3. sp_SrvPermissions & sp_DBPermissions V5.0

    2

    June 23, 2014 by Kenneth Fisher

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

  4. I don’t want to grant permission to all the tables in the database at once.

    1

    June 16, 2014 by Kenneth Fisher

    A couple of weeks ago I did a post on granting or denying permissions to all the tables within a …
    Continue reading

  5. Granting or denying permissions to all of the tables within a database

    2

    May 15, 2014 by Kenneth Fisher

    When granting or denying permissions to the tables within a database you have two options. You can either add the …
    Continue reading

  6. 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

  7. 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

  8. 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

  9. 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

  10. 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

Follow

Get every new post delivered to your Inbox.

Join 305 other followers