Dec 15, 2011 | IanT, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQLServerPedia Syndication |
Written by Ian Treasure Gethyn posted on the use of execute permissions a while ago (db_executor at http://www.gethynellis.com/2010/04/dbexecutor-role.html). Briefly, this approach uses a role – db_Executor – to which users are given membership. The execute permission...
Aug 3, 2011 | IanT, SQL Server 2008 R2, SQL Server Denali |
Written by Ian Treasure Gethyn recently posted on deleting from a view. He used a common situation where several tables are joined into one view. In simpler situations, views can be updated directly. If required, triggers can be used to allow updates to views...
