Tag Archives: Impersonation
-
db_owner in msdb == sysadmin
2May 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 -
Can SQL Ids be used on an instance with Windows Authentication only?
2April 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 -
The trials and tribulations of REVERTing from impersonation
1May 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 -
What is impersonation for?
3December 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 -
Using impersonation to allow a task without granting the required permission.
9August 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 -
Impersonation can give you the wrong answer
1February 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
SQL Studies 