Tag Archives: server permissions

  1. Permissions Posters

    2

    July 27, 2015 by Kenneth Fisher

    I’ve been doing a lot of research recently for my permissions session and for a project at work. During said …
    Continue reading

  2. Using sp_DBPermissions and sp_SrvPermissions v6.0

    1

    February 25, 2015 by Kenneth Fisher

    It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting. …
    Continue reading

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

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

    5

    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

  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. Impersonating a server level permission

    5

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

  10. How do I move a SQL login from one server to another without the password?

    13

    March 25, 2013 by Kenneth Fisher

    This is an uncommon task but one that does turn up every once in awhile. A SQL login has to …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 798 other followers