microsoft / microsoft/DacFx

Project build fails for valid Revoke script

Open
#598 1 comment 0 reactions 0 assignees View on GitHub
area: build sdk bug
Dominant language
C#
Stars
460
Forks
29
Avg merge
4d 9h
Merged PRs (30d)
7

Description

- SqlPackage or DacFx Version:
- .NET Framework (Windows-only) or .NET Core:
- Environment (local platform and source/target platforms):

**Steps to Reproduce:**

1. Create a db project with a procedure and this script "CREATE PROCEDURE sp_revoke_b AS REVOKE SELECT ON dbo.B TO TestLogin01"
2. Build the project
Expected: the project builds successfully
Actual: Error occurred: Error SQL70593: REVOKE statements are only supported for columns.

**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

Start by reproducing the build with a database project containing the procedure and REVOKE script shown in the issue, using the relevant DacFx or SqlPackage entry point. Investigate why the build reports SQL70593 for a table-level REVOKE; done means the valid script builds successfully, with regression coverage if the existing project provides a suitable test location.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp, sql
Domain
build-system, database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Clearly specified
Newbie friendliness
64/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.