GRANT EXECUTE ANY EXTERNAL SCRIPT not recognised by SSDT
The permission GRANT EXECUTE ANY EXTERNAL SCRIPT is not recognised by SSDT therefore makes dacpac deployment of a project using R (and I guess Python too) services a hassle.
This is broken in all versions of SSDT up to and including 17.3.
Mickey Cohen commented
Tried using exclude permissions as well as running REVOKE EXECUTE... still facing this issue. Is this going to be fixed? Are there any other workarounds?
Christoph Muthmann commented
Still the same problem with the dacpac for me (SQL Server 2017 CU #15)
Joel Ewald commented
Within SSDT I can get around the error by going to Advanced Publish settings and under Ignore (tab) check "Exclude Permissions"
Not ideal, but at least it will compare and deploy.
Also receive this error when trying to deploy a dacpac to a database that has this permission granted:
Error SQL72018: Permission could not be imported but one or more of these objects exist in your source.