-
August 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 reading
Category: 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
-
August 5, 2013 by Kenneth Fisher
Over the last year of blogging my thoughts and queries I’ve discovered something interesting. I posted Where is my Backup? …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: code language, language sql, microsoft sql server, principals, security, sql statements, T-SQL, users
-
July 17, 2013 by Kenneth Fisher
I make a point of reading DBAReactions on a fairly regular basis and today while reading it I was lead …
Continue reading
Category: Microsoft SQL Server, Security, Settings, SQLServerPedia Syndication, SSMS
| Tags: security, SSMS
-
May 30, 2013 by Kenneth Fisher
A couple of months ago I talked about moving a login from one server to another without the password. The …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL
| Tags: code language, dynamic sql, language sql, microsoft sql server, security, sql statements, T-SQL
-
March 25, 2013 by Kenneth Fisher
This is an uncommon task but one that does turn up every once in awhile. A SQL login has to …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL
| Tags: language sql, microsoft sql server, security, server permissions, sql statements, system functions, T-SQL
-
March 1, 2013 by Kenneth Fisher
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL
| Tags: code language, language sql, microsoft sql server, security, server permissions, T-SQL
-
December 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 reading
Category: DMV, Microsoft SQL Server, Security, SQLServerPedia Syndication
| Tags: database permissions, DMV, microsoft sql server, security, server permissions
-
September 9, 2012 by Kenneth Fisher
As a database administrator I get lots of security requests. “Please grant me read authority on this table, write on that table, …
Continue reading
Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL
| Tags: code language, microsoft sql server, security
SQL Studies 