Tag Archives: database 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
-
sp_DBPermissions
3August 14, 2013 by Kenneth Fisher
Last week I posted a series of database permissions scripts. I’ve been using them quite a bit over the last …
Continue readingCategory: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL | Tags: database permissions, dynamic sql, language sql, microsoft sql server, security, system functions
-
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 