microsoft / microsoft/DacFx

Server level permissions are not allowed

Open
#302 0 comments 0 reactions 0 assignees View on GitHub
bug
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.