Tag Archives: security
-
SA Spoof
14September 8, 2016 by Kenneth Fisher
This is nothing new but it’s still a fun idea. The problem: The vendor app we just purchased (and are …
Continue reading -
Cloud Security
1August 22, 2016 by Kenneth Fisher
In case you hadn’t noticed I’ve recently started looking at the cloud and what it entails. Well one of those …
Continue reading -
Using impersonation to allow a task without granting the required permission.
7August 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 -
Grant Deny Revoke
2May 4, 2016 by Kenneth Fisher
It always amazes me how often these three commands get confused. Heck it amazes me how long I confused them. …
Continue reading -
Certificates, Proxies and Jobs! Oh My!
2April 27, 2016 by Kenneth Fisher
Oh Noes! I have a job that requires me to run an SSIS package, cmdshell script, etc. And I need …
Continue reading -
I’m presenting for the Pass Security Virtual Chapter!
1March 23, 2016 by Kenneth Fisher
Tomorrow (3/24/2016) at noon CT I’ll be presenting my SQL Server Security Basics session for the Pass Security Virtual Chapter. …
Continue reading -
What permissions do I need?
Leave a commentMarch 16, 2016 by Kenneth Fisher
Ever wondered how to tell what permissions are required to run a statement or perform a task? Well, sometimes it …
Continue reading -
You don’t need to be a sysadmin
16March 10, 2016 by Kenneth Fisher
Hey, I need sysadmin access to ServerA. Ok. Why do you need sysadmin? Well I need to be able to …
Continue reading -
How do I grant someone the ability to create a stored procedure?
1March 2, 2016 by Kenneth Fisher
The question of How to grant the ability to create/alter stored procedures and views came up today on dba.stackexchange.com. It’s …
Continue reading
