Tag Archives: database 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
-
TSQL Tuesday #63: – DBA Myths: You can’t deny something to a member of db_owner database role
12February 10, 2015 by Kenneth Fisher
So I’m hosting T-SQL Tuesday this month and decided that since security is something everyone has to deal with it …
Continue readingCategory: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL Tuesday | Tags: database permissions, microsoft sql server, security
-
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
-
Deny vs Revoke
3August 4, 2014 by Kenneth Fisher
Quick quiz. Which of these two commands is the opposite of GRANT? DENY REVOKE Well lets start with some …
Continue readingCategory: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL | Tags: code language, database permissions, language sql, microsoft sql server, security, T-SQL
-
db_ddladmin and the SSMS table designer
Leave a commentJuly 10, 2014 by Kenneth Fisher
If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you …
Continue readingCategory: Microsoft SQL Server, Problem Resolution, Security, SQLServerPedia Syndication, SSMS | Tags: database permissions, microsoft sql server, problem resolution, security, SSMS
-
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
-
Granting or denying permissions to all of the tables within a database
2May 15, 2014 by Kenneth Fisher
When granting or denying permissions to the tables within a database you have two options. You can either add the …
Continue readingCategory: Microsoft SQL Server, Security, SQLServerPedia Syndication, SSMS | Tags: database permissions, microsoft sql server, security, SSMS
-
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
SQL Studies 