May 1, 2015 at 12:14 pm
In my organization, we give the developers dbreader, dbwriter and ddladmin database roles in the non-prod environments and in the SQL Server 2008R2 ALTER TRIGGER worked, but now it doesn't and says that they need to be dbowner or sysadmin fixed role.
Any help on this one would be greatly appreciated.
May 1, 2015 at 1:06 pm
According to this BOL article, you need ALTER TABLE on the table the trigger, and according to this BOL article, db_ddladmin does not have ALTER TABLE.
I tend to create specific database roles for things like this. You can then grant that role the ALTER TABLE permissions, put the developers in the new role and put the new rols in the fixed roles you need.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply