MemberJunction / MemberJunction/MJ

Audit MJ core entity schema permissions

Open
#2,211 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
TSQL
Stars
29
Forks
6
Avg merge
2d 1h
Merged PRs (30d)
323

Description

There may be other core MJ entities beyond `MJ: Datasets` and `MJ: Dataset Items` where `EntityPermission` records have incorrect write flags — either missing permissions that should exist or permissions granted that shouldn't be. This was never systematically audited.

**Action needed:**
- Review all core MJ entity `EntityPermission` records for `cdp_Developer`, `cdp_Integration`, and `cdp_UI` roles
- Verify `GRANT EXECUTE` exists on all SPs where write permissions are enabled
- Fix any gaps found and emit corrections via CodeGen or migration in v5.16

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.