Tag Archives: security

  1. T-SQL Tuesday #58: Passwords

    2

    September 9, 2014 by Kenneth Fisher

    It’s that time again. The second Tuesday of each month we have a blog party called T-SQL Tuesday. The host …
    Continue reading

  2. Deny vs Revoke

    1

    August 4, 2014 by Kenneth Fisher

    Quick quiz. Which of these two commands is the opposite of GRANT? DENY REVOKE   Well lets start with some …
    Continue reading

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

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

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

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

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

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

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

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

Follow

Get every new post delivered to your Inbox.

Join 423 other followers