Competition: What’s your favorite Redgate tool? Enter now.

Delegating SQL Compare and SQL Data Compare to Application Role when using SDK

We use the SQL Compare and SQL Data Compare SDKs in order to allow our installer program to upgrade our application databases in SQL Server. Our application runs on SQL server 2008 R2 or greater. We would like to allow the user executing the installer to be a lower-privileged user (integrated security) than the db_owner access needed to perform all the appropriate changes. Our thinking is to create an "installer" application role in SQL that the application can then utilize by running the sp_setapprole stored procedure. This would then let the application execute the desired compares and deploys with the appropriate privileges since they will be granted by the application role. 

Is there a way to do this with the using the SDK? 
Tagged:

Answers

Sign In or Register to comment.