Server level permissions are not allowed
- Dominant language
- C#
- Stars
- 460
- Forks
- 29
- Avg merge
- 4d 9h
- Merged PRs (30d)
- 7
Description
- SqlPackage or DacFx Version: 16.1.8089.0
- .NET Framework (Windows-only) or .NET Core: .NET Framework Version: 4.8.1 or later
- Environment (local platform and source/target platforms): Windows 11 | Visual Studio 2022 | SQL Server 2019
**Steps to Reproduce:**
1. Add a script with Build Action 'Build' in SSDT with the following command:
GRANT UNSAFE ASSEMBLY TO guest;
2. Build your project in SSDT and you get the error :
Severity Code Description Project File Line Suppression State
Error SQL70018: Server level permissions are not allowed.
**Did this occur in prior versions? If not - which version(s) did it work in?**
(DacFx/SqlPackage/SSMS/Azure Data Studio)
Contributor guide
Research direction
Reproduce the SSDT build on Windows 11 with SQL Server 2019 using a Build Action 'Build' script containing `GRANT UNSAFE ASSEMBLY TO guest;`. Start by tracing where DacFx validates server-level permissions; done means the reported SQL70018 behavior is resolved or clearly documented for this statement.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- build-system, database
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100