Jun 9, 2010 | Security, SQL Server 2005, SQL Server 2008 |
You can probably tell from some of my more recent posts that I have been doing some work lately on SQL Server 2008. I have also recently (the last two months) upgraded my work desktop to Windows 7. As a result of this of this, and the continued migration away from SQL...
Apr 12, 2010 | Scripts, Security, SQL Server 2005, SQL Server 2008 |
The process of creating a db_executor might not be granular enough for some but there is a nice simple way of creating a database role in a SQL Server database (called db_executor) and granting the db_executor role execute permissions on all stored...
Mar 30, 2010 | Security, SQL Server 2008, SQLServerPedia Syndication |
Today I discovered, from a post on the forums and a follow up dig into BOL that sp_change_users_login is to be depreciated in future versions of SQL Server and the new ALTER USER should be used instead. Now let me make it clear here, sp_change_users_login is...
Feb 28, 2010 | Permissions, Security, SQLServerPedia Syndication |
There are some new database roles in the MSDB database in SQL Server 2005 that allow you to grant more granular permission to non-sa users in the SQL Server agent. If you work in an environment similar to the one i support, application and database code will...
Feb 21, 2010 | Permissions, Security |
I recently restored a SQL Server 2005 database to a testing environment. The database contained several CLR assemblies, when the tester tried to execute one of the CLR’s SQL returned the following error: An error occurred in the Microsoft .NET Framework while trying...
