microsoft / microsoft/vscode-mssql
Schema Compare wants to remove db level permissions
- Dominant language
- TypeScript
- Stars
- 1.9k
- Forks
- 610
- Avg merge
- 2d 3h
- Merged PRs (30d)
- 97
Description
Type: Bug
run a schema compare copmparing a SQL Server database to a local project. We have db level permissions granting some users CONNECT. They are defined in the project and checking the db, they are granted. Switching direction of compare shows it as an add. same result in VS Code and SSMS
Extension version: 1.6.2
VS Code version: Code - Insiders 1.134.0-insider (f844934f854c9277a48627aac77ebcea69591ae1, 2026-08-11T22:56:11Z)
OS version: Windows_NT x64 10.0.26100
Modes:
System Info
|Item|Value|
|---|---|
|CPUs|Intel(R) Xeon(R) Platinum 8488C (4 x 2400)|
|GPU Status|2d_canvas: unavailable_software
GPU0: VENDOR= 0x1414, DEVICE=0x008c [Microsoft Basic Render Driver], DRIVER_VENDOR=Microsoft, DRIVER_VERSION=10.0.26100.33158 *ACTIVE*
GPU1: VENDOR= 0x1414, DEVICE=0x008c [Microsoft Basic Render Driver], DRIVER_VERSION=10.0.26100.33158
GPU2: VENDOR= 0x1414, DEVICE=0x008c [Microsoft Basic Render Driver], DRIVER_VERSION=10.0.26100.33158
Machine model name:
Machine model version:
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: disabled_software
multiple_raster_threads: enabled_on
opengl: disabled_off
rasterization: disabled_software
raw_draw: disabled_off_ok
skia_graphite: disabled_off
trees_in_viz: disabled_off
video_decode: disabled_software
video_encode: disabled_software
webgl: unavailable_software
webgpu: unavailable_software
webnn: unavailable_software|
|Load (avg)|undefined|
|Memory (System)|15.62GB (6.48GB free)|
|Process Argv|--crash-reporter-id 0a26f89c-93b6-4048-866e-de132b9afa0c|
|Screen Reader|yes|
|VM|0%|
A/B Experiments
```
vsliv368cf:30146710
pythonvspyt551:31249597
nativeloc1:31118317
dwcopilot:31158714
dwoutputs:31242946
copilot_t_ci:31333650
g012b348:31231168
pythonrdcb7:31268811
pythonpcpt1cf:31399617
6518g693:31302842
envsactivate1:31349248
editstats-enabled:31346256
cloudbuttont:31366566
42190218_ostrepl:31403339
cp_cls_t_966_ss:31526232
4je02754:31455664
c3h7c220:31478652
cp_cls_c_1081:31454833
conptydll_true:31485575
e9c30283:31453065
test_treatment2:31471001
46204921:31447328
ei9d7968:31462942
ah:31461780
89g7j272:31506658
7e884298:31462391
i2gc6536:31472020
52612955:31508042
h08i8180_copy:31475366
ddid_t:31478204
hmra_i5g22:31518061
bjc72774_agent_sandbox:31538428
7df3h592:31491241
cp_cls_t_1082:31535311
logging_enabled_new:31490725
jb_cp_cls_t_632:31543129
32d76977:31503652
ha629193:31508444
cdk-lw-on:31524445
a1ije391_t:31533808
jbcp_cls_pctr_t:31531130
cp_intellij_t_nes:31548657
jf4hg949:31526829
hide-eh-duplicates:31543293
replace-eh-with-ah:31545853
ihg5j128:31534457
f412h606:31543414
nes-ex-cf-euporie-03:31542847
enable_editor_pane_layout:31551200
52258b4d:31547953
36h42362:31560305
c7c27ce7:31551212
6577i413_copy:31558653
1h923230:31564177
1532g621_copy:31554310
treatment-23-1:31555779
unuse_dynamic_mcp:31555281
0c1h4866:31562347
ai4g2856_c:31561844
j66cb542_t:31561847
5b8j3302:31564600
mangle-name-control:31565184
```
Contributor guide
No contributing guide indexed for this repository
Research direction
No file or test is named in the report. First reproduce the schema compare in VS Code or SSMS with a database-level CONNECT permission defined and granted in the project; done means reversing the comparison no longer falsely reports that permission as an add or removal.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql, typescript
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 55/100