Visual Studio 2008 Database Edition GDR - Finer Grain control of User, Schema, & Permission scripting

Visual Studio 2008 Database Edition GDR - Finer Grain control of User, Schema, & Permission scripting by mweber3

Closed

as Postponed Help for as Postponed

Type:	Suggestion
ID:	424035
Opened:	3/16/2009 7:26:24 AM
Access Restriction:	Public

Workaround(s)

view

In our organization, the development team does not manage users for databases. This means we don't have any user objects in our Visual Studio 2008 Database Edition GDR projects. We do have database roles and mappings of permissions to objects to those roles. The DBAs would then grant users access to roles after deployment. With the GDR we need the ability to suppress the DROP USER, DROP SCHEMA, and REVOKE CONNECT scripts that are output to the difference script during deployment using VSDBCMD. There is an option to IgnorePermissions in the *.sqldeployment file that will suppress the REVOKE CONNECT scripts but this also removes any permissions we grant to database roles for objects in the *.sqlpermissions file which we do not want. In addition there isn't any option to "Ignore Users" or "Ignore Schemas".

Details (expand)

English

Visual Studio 2008 SP1

Windows XP Professional

English

No way to suppress User, Schema, and User connect scripts when "Generate DROP statements" option is on and VSDBCMD is used to build and deploy difference scripts to target database.

Add advanced options to *.sqldeployment file:
Ignore Users
Ignore Schemas
Ignore User permissions - to suppress REVOKE CONNECT scripts but allow OBJECT permissions defined in *.sqlpermissions file.

0 attachments

Posted by noonie on 4/28/2010 at 9:58 PM

The ability to omit the DROP user statements from the deployment sql file is very important to us, especially for incremental deployments to multiple databases in multiple environments. We do not model users in our projects but use database roles and application roles for our applications. Users, and other security objects, are solely under the control of the administrators of our environments and frankly none of our (developers) business.

Presently we are working around this by turning off "Generate DROP statements for objects that are in the target database..." deployment option and handling the dropping of schema objects in pre/post deployment scripts but this is not ideal.

Posted by Microsoft on 3/4/2010 at 3:22 PM

mweber3,

Thank you for submitting this feedback. We have captured this feedback in our product backlog and it will be considered for future improvements to the Visual Studio Database Development Tools.

In VS 2010 we have added some lower level drop options for deployment that allow dropping indexes and constraints not defined in the project. We will consider expading this to also include the users, schemas, etc, options as well.

Thanks,

Barclay Hill
Program Manager | Visual Studio Product Team (Team Engineering - Database Tools) | Microsoft Corporation

Posted by Microsoft on 3/17/2009 at 3:24 AM

Thanks for your feedback. We are escalating your feedback to the product unit who works on that specific feature area. The product team will review your feedback and make a decision on whether they will fix it or not for the next release.