Tag Archives: database permissions

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

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

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

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

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

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

  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. Logins vs Users

    14

    December 3, 2012 by Kenneth Fisher

    Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems. …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 379 other followers