Tag Archives: server permissions
-
sp_SrvPermissions & sp_DBPermissions V5.0
2June 23, 2014 by Kenneth Fisher
These are a couple of stored procedures I wrote to help me with security research. Each of the stored procedures …
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
-
Impersonating a server level permission
12February 26, 2014 by Kenneth Fisher
Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s …
Continue readingCategory: Impersonation, Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL | Tags: code language, database permissions, Impersonation, language sql, microsoft sql server, security, server permissions, sql statements, T-SQL
-
sp_SrvPermissions & sp_DBPermissions V4.0
Leave a commentJanuary 15, 2014 by Kenneth Fisher
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data …
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
-
sp_SrvPermissions & sp_DBPermissions V3.0
Leave a commentNovember 4, 2013 by Kenneth Fisher
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data …
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
-
How do the fixed Database and Server roles map to more specific permissions?
Leave a commentSeptember 9, 2013 by Kenneth Fisher
I recently asked what the difference is between granting SELECT to a user (at a database level) and adding the …
Continue readingCategory: Documentation, Microsoft SQL Server, Security, Settings, SQLServerPedia Syndication | Tags: database permissions, Documentation, microsoft sql server, security, server permissions
-
How do I move a SQL login from one server to another without the password?
18March 25, 2013 by Kenneth Fisher
This is an uncommon task but one that does turn up every once in awhile. A SQL login has to …
Continue readingCategory: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL | Tags: language sql, microsoft sql server, security, server permissions, sql statements, system functions, T-SQL
-
Script to clean up “Windows” logins no longer in AD
14March 1, 2013 by Kenneth Fisher
I was scanning http://dba.stackexchange.com and ran across the following question: http://dba.stackexchange.com/questions/31478/sql-server-script-to-delete-accounts-no-longer-in-active-directory Basically the OP wanted to know how to get …
Continue readingCategory: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL | Tags: code language, language sql, microsoft sql server, security, server permissions, T-SQL
-
Logins vs Users
20December 3, 2012 by Kenneth Fisher
Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems. …
Continue readingCategory: DMV, Microsoft SQL Server, Security, SQLServerPedia Syndication | Tags: database permissions, DMV, microsoft sql server, security, server permissions
SQL Studies 