Tag Archives: database permissions

  1. TSQL Tuesday #63: – DBA Myths: You can’t deny something to a member of db_owner database role

    12

    February 10, 2015 by Kenneth Fisher

    So I’m hosting T-SQL Tuesday this month and decided that since security is something everyone has to deal with it …
    Continue reading

  2. Discussing Security with Boris Hristov on SQLHangout #29

    Leave a comment

    January 12, 2015 by Kenneth Fisher

    Over the years I’ve done a number of posts on various aspects of security. In fact the first thing I …
    Continue reading

  3. TSQL Tuesday #60: Something New Learned – What permissions does <username> have?

    6

    November 11, 2014 by Kenneth Fisher

    What have I learned recently? Well as it happens I learned something rather interesting recently and was actually trying to …
    Continue reading

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

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

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

  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

    10

    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

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

Join 3,148 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013