microsoft / microsoft/DacFx

SSDT for synapse dw project Maintain user permission after table change published

Open
#643 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

sqldw
Dominant language
C#
Stars
460
Forks
29
Avg merge
4d 9h
Merged PRs (30d)
7

Description

**Is your feature request related to a problem? Please describe.**
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

**Describe the solution you'd like**
Please describe the desired behavior.

**Describe alternatives you've considered**
A clear and concise description of any alternative solutions or features you've considered.

**Additional context**
Add any other context or screenshots about the feature request here.

Description:
SSDT for synapse dw project Maintain user permission after table change published
Customer Scenario:

Keep user permission after table column changes

cx is using github + ssdt to source control DEV, UAT, PROD envrionments, if they change a column type etc will result in table rebuild(build new table, import data from old table to new table, drop old table, rename new table), cx did not maintain user permission in source control as they wish to maintain different permission in different environment, thus user permission will be lost after table rebuild.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

The issue does not name an implementation file, test, or entry point. Start by clarifying how SSDT for Synapse data warehouse projects represents permissions and table rebuilds, including the expected behavior across environments. Done means publishing a table column change preserves the intended user permissions.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.