June 14, 2012 at 3:46 pm
Developers have dbo permissions in the DEV environment so they were able to create database diagrams in the database. Now they want to promote this database up to test and production using backup and restore instead of scripting just the objects needed. When the first diagram is created SSMS adds a table dbo.sysdiagrams, a function fn_diagramobjects and several stored procedures for working with the diagrams (and to change the table schema when the diagram is edited). our report of what permissions are granted in the database also show execute being granted to public for all of these procs.
What I want to do is remove all of this stuff before moving the database to the the more secure test and production environments. Are there any potential issues with just dropping the objects from the database and removing the execute grants?
June 15, 2012 at 7:27 am
No issues. That's how I do it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply