Tag Archives: Impersonation


    Leave a comment

    July 26, 2022 by Kenneth Fisher

    I use impersonation a lot. It’s a really easy way to check if someone has the permissions they are supposed …
    Continue reading

  2. db_owner in msdb == sysadmin


    May 6, 2019 by Kenneth Fisher

    This doesn’t require much in the way discussion. This isn’t exactly a huge issue since I don’t think granting db_owner …
    Continue reading

  3. Can SQL Ids be used on an instance with Windows Authentication only?


    April 11, 2019 by Kenneth Fisher

    tl;dr; Yes, but. It’s generally considered more secure to have your SQL Server instance set to Windows Authentication and not …
    Continue reading

  4. The trials and tribulations of REVERTing from impersonation


    May 16, 2018 by Kenneth Fisher

    Impersonation is a highly useful tool in your toolbox. With the EXECUTE AS clause you can allow your stored procedure …
    Continue reading

  5. What is impersonation for?


    December 27, 2017 by Kenneth Fisher

    I was doing some research on impersonation the other day, and among other things, I ran across a forum question …
    Continue reading

  6. Using impersonation to allow a task without granting the required permission.


    August 1, 2016 by Kenneth Fisher

    I use impersonation on a regular basis for a number of different tasks. This one is pretty basic but can …
    Continue reading

  7. Impersonation can give you the wrong answer


    February 8, 2016 by Kenneth Fisher

    I use impersonation all the time to let me see additional permissions information I can only get that way and, …
    Continue reading

  8. Impersonating a server level permission


    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

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

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013