-
February 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 reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL Tuesday
| Tags: database permissions, microsoft sql server, security
-
February 3, 2015 by Kenneth Fisher
Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL Tuesday
| Tags: Adam Machanic, microsoft sql server, security, T-SQL Tuesday
-
January 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 reading
Category: Microsoft SQL Server, Security, SQL Hangout, SQLServerPedia Syndication
| Tags: Boris Hristov, database permissions, microsoft sql server, security, server permissions, SQL Hangout
-
December 29, 2014 by Kenneth Fisher
I work for a large organization that over the last few years has been doing a LOT of reorgs. And …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication
| Tags: code language, language sql, microsoft sql server, security, sql statements
-
November 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 reading
Category: 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
-
September 9, 2014 by Kenneth Fisher
It’s that time again. The second Tuesday of each month we have a blog party called T-SQL Tuesday. The host …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL Tuesday
| Tags: Argenis Fernandez, hashing, microsoft sql server, security, T-SQL Tuesday
-
August 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 reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL
| Tags: code language, database permissions, language sql, microsoft sql server, security, T-SQL
-
July 21, 2014 by Kenneth Fisher
I seem to get a lot of permissions questions these days and one of the more frequent ones goes along …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication
| Tags: microsoft sql server, role, security
-
July 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 reading
Category: Microsoft SQL Server, Problem Resolution, Security, SQLServerPedia Syndication, SSMS
| Tags: database permissions, microsoft sql server, problem resolution, security, SSMS
-
June 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 reading
Category: 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 