SQLPackage no longer revokes permissions on object when removed. How do I do that again?

Erick 0 Reputation points
2024-06-24T22:25:46.49+00:00

Using SQLPackage we create a Deployment Script and a Rollback Script using DacPac's
We have a Current Dacpac of what the current production server contains and then we have a Dacpac created out of Visual Studio with what it is currently. We create a script based off of the two Dacpacs.

This has worked well for us creating both a Deployment script and a Rollback script based on the two Dacpac's.

We had not updated SQLPackage for some time.

We updated to the newest SQLPackage nothing else has changed. SQLPackage will still create the deployement script (GRANT SELECT ON OBJECT:: ....)
But no longer creates (REVOKE SELECT ON OBJECT::....)

Is there a new default of option for creating the REVOKE statement when creating a script and comparing two DacPacs?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,028 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.