Tag Archives: server permissions
-
EXECUTE AS USER vs EXECUTE AS LOGIN
Leave a commentJuly 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 readingCategory: Microsoft SQL Server, Security, SQLServerPedia Syndication | Tags: database permissions, Impersonation, microsoft sql server, principals, security, server permissions
-
Simple Security Report
2May 1, 2017 by Kenneth Fisher
Quite a while ago I created a couple of little security scripts to help me out with permissions research. Over …
Continue readingCategory: Microsoft SQL Server, Security, SQLServerPedia Syndication | Tags: database permissions, microsoft sql server, security, server permissions
-
sp_SrvPermissions & sp_DBPermissions V6.0 Finally!
7March 27, 2017 by Kenneth Fisher
It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well, …
Continue readingCategory: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL | Tags: code language, database permissions, dynamic sql, language sql, microsoft sql server, security, server permissions
-
The CONNECT permission
11January 27, 2016 by Kenneth Fisher
The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at …
Continue readingCategory: Microsoft SQL Server, Security, SQLServerPedia Syndication | Tags: database permissions, microsoft sql server, security, server permissions
-
Administrative Logins and Users
3November 2, 2015 by Kenneth Fisher
If you’ve ever worked through an audit you have probably gotten a request that looks a lot like this: Please …
Continue readingCategory: Auditing, Microsoft SQL Server, Security, SQLServerPedia Syndication | Tags: database permissions, microsoft sql server, security, server permissions
-
Zombie AD Groups
4September 21, 2015 by Kenneth Fisher
I spent something like 2 hours today trying to figure out how a particular user had access to one of …
Continue readingCategory: Microsoft SQL Server, Security, SQLServerPedia Syndication | Tags: database permissions, microsoft sql server, security, server permissions
-
Permissions Posters
3July 27, 2015 by Kenneth Fisher
I’ve been doing a lot of research recently for my permissions session and for a project at work. During said …
Continue readingCategory: Documentation, Microsoft SQL Server, Security, SQLServerPedia Syndication | Tags: database permissions, Documentation, microsoft sql server, perm, security, server permissions
-
Using sp_DBPermissions and sp_SrvPermissions v6.0
1February 25, 2015 by Kenneth Fisher
It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting. …
Continue readingCategory: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL | Tags: code language, database permissions, DMV, dynamic sql, language sql, microsoft sql server, security, server permissions, system functions, T-SQL
-
Discussing Security with Boris Hristov on SQLHangout #29
Leave a commentJanuary 12, 2015 by Kenneth Fisher
Over the years I’ve done a number of posts on various aspects of security. In fact the first thing I …
Continue readingCategory: Microsoft SQL Server, Security, SQL Hangout, SQLServerPedia Syndication | Tags: Boris Hristov, database permissions, microsoft sql server, security, server permissions, SQL Hangout
-
TSQL Tuesday #60: Something New Learned – What permissions does <username> have?
7November 11, 2014 by Kenneth Fisher
What have I learned recently? Well as it happens I learned something rather interesting recently and was actually trying to …
Continue readingCategory: Microsoft SQL Server, Security, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL Tuesday | Tags: code language, database permissions, language sql, microsoft sql server, security, server permissions, T-SQL, T-SQL Tuesday
SQL Studies 