-
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
-
February 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 reading
Category: 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
-
January 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 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
-
November 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 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
-
October 9, 2013 by Kenneth Fisher
This happens to me all the time. I get a request from a developer to overwrite the test copy of …
Continue reading
Category: Backups, Microsoft SQL Server, Problem Resolution, Security, SQLServerPedia Syndication
| Tags: backups, microsoft sql server, problem resolution, security
-
September 18, 2013 by Kenneth Fisher
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: language sql, microsoft sql server, security, system functions, T-SQL
-
September 18, 2013 by Kenneth Fisher
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: language sql, microsoft sql server, security, system functions
-
September 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 reading
Category: Documentation, Microsoft SQL Server, Security, Settings, SQLServerPedia Syndication
| Tags: database permissions, Documentation, microsoft sql server, security, server permissions
-
August 19, 2013 by Kenneth Fisher
Last week I posted my stored procedure for database permissions, sp_DBPermissions. A couple of days later I was demonstrating it …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication
| Tags: code language, dynamic sql, language sql, microsoft sql server, security, T-SQL
SQL Studies 