Tag Archives: server permissions

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

    2

    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

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

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

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

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

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

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

  8. Script to clean up “Windows” logins no longer in AD

    7

    March 1, 2013 by Kenneth Fisher

    I was scanning http://dba.stackexchange.com and ran across the following question: http://dba.stackexchange.com/questions/31478/sql-server-script-to-delete-accounts-no-longer-in-active-directory Basically the OP wanted to know how to get …
    Continue reading

  9. 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 491 other followers