Category Archives: Security
-
Windows Hello may cause a “SSPI Context” error
2August 22, 2023 by Kenneth Fisher
I’m going to start out by saying I don’t know a tremendous amount about this subject. I’ll tell you what …
Continue reading -
db_ddladmin Jr.
1July 20, 2023 by Kenneth Fisher
A while back I talked about the fact that you can grant someone CREATE PROCEDURE and ALTER on a schema …
Continue reading -
How do I tell if a user is orphaned or actually created without a login?
5July 18, 2023 by Kenneth Fisher
One of the wonderful things about blogging is the ability to make notes for future me. Which is basically what …
Continue reading -
The two hardest concepts of security are Who? and Where?
3July 13, 2023 by Kenneth Fisher
I was having a conversation with some friends the other day and Jen McCown (blog|twitter) asked about SQL Server security …
Continue reading -
What you can do is based on more than your direct permissions.
1October 6, 2022 by Kenneth Fisher
What you have access to is not just what you have direct permissions to. The other day I needed to …
Continue reading -
Viewing errors with extended events
3September 27, 2022 by Kenneth Fisher
A little while back I came across this post: Identifying failed queries with extended events. It has a script to …
Continue reading -
Creating a SERVER ROLE created a LOGIN as well.
1September 6, 2022 by Kenneth Fisher
One of my co-workers came to me the other day and told me that they found their network id as …
Continue reading -
Why is security important in a dev environment?
10August 23, 2022 by Kenneth Fisher
I was asked a rather interesting question during an interview recently. It went something like this: Your resume says you’ve …
Continue reading -
New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo
Leave a commentAugust 18, 2022 by Kenneth Fisher
I’ve added a new parameter to my permissions scripts (well, just the main two for now). Fair warning, it’s in …
Continue reading
SQL Studies 