Category Archives: Security
-
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
7March 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 -
You are not logged on as the database owner or system administrator.
Leave a commentFebruary 22, 2016 by Kenneth Fisher
I had one of my developers ask me why he keeps seeing the following warning when he tries to modify …
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 -
Do you check for TRUSTWORTHY databases as part of your security audits?
7December 30, 2015 by Kenneth Fisher
I ran a twitter poll the other day Do you check for databases with trustworthy turned on when you do …
Continue reading -
Questions from “SQL Server Security for Everyone”
2November 4, 2015 by Kenneth Fisher
I recently gave my SQL Server Security for Everyone session at Summit 2015. (I’m still in awe about that by …
Continue reading
