-
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
-
June 16, 2014 by Kenneth Fisher
A couple of weeks ago I did a post on granting or denying permissions to all the tables within a …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication
| Tags: microsoft sql server, object permissions, schema permissions, security
-
May 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 reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, SSMS
| Tags: database permissions, microsoft sql server, security, SSMS
SQL Studies 