-
March 10, 2016 by Kenneth Fisher
Hey, I need sysadmin access to ServerA. Ok. Why do you need sysadmin? Well I need to be able to …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication
| Tags: security
-
March 2, 2016 by Kenneth Fisher
The question of How to grant the ability to create/alter stored procedures and views came up today on dba.stackexchange.com. It’s …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication
| Tags: microsoft sql server, security
-
February 22, 2016 by Kenneth Fisher
I had one of my developers ask me why he keeps seeing the following warning when he tries to modify …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication
| Tags: microsoft sql server, security
-
February 8, 2016 by Kenneth Fisher
I use impersonation all the time to let me see additional permissions information I can only get that way and, …
Continue reading
Category: Impersonation, Microsoft SQL Server, Security, SQLServerPedia Syndication
| Tags: Impersonation, microsoft sql server, security
-
January 27, 2016 by Kenneth Fisher
The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication
| Tags: database permissions, microsoft sql server, security, server permissions
-
December 30, 2015 by Kenneth Fisher
I ran a twitter poll the other day Do you check for databases with trustworthy turned on when you do …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication
| Tags: database settings, microsoft sql server, security
-
November 12, 2015 by Kenneth Fisher
This isn’t something you have to do frequently, but sometimes you don’t want the users to have access to certain …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL
| Tags: microsoft sql server, object permissions, security
-
November 4, 2015 by Kenneth Fisher
I recently gave my SQL Server Security for Everyone session at Summit 2015. (I’m still in awe about that by …
Continue reading
Category: Microsoft SQL Server, Pass, Security, Speaking, SQLServerPedia Syndication
| Tags: microsoft sql server, security, speaking
-
November 2, 2015 by Kenneth Fisher
If you’ve ever worked through an audit you have probably gotten a request that looks a lot like this: Please …
Continue reading
Category: Auditing, Microsoft SQL Server, Security, SQLServerPedia Syndication
| Tags: database permissions, microsoft sql server, security, server permissions
-
September 21, 2015 by Kenneth Fisher
I spent something like 2 hours today trying to figure out how a particular user had access to one of …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication
| Tags: database permissions, microsoft sql server, security, server permissions
SQL Studies 