Project build fails for valid Revoke script
- 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
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