microsoft / microsoft/vscode-mssql

[Feature Request]: Option to Show Only Accessible Schemas for Current User

Open
#20,057 1 comment 0 reactions 0 assignees View on GitHub
Area - Object Explorer Enhancement Under evaluation User-filed
Dominant language
TypeScript
Stars
1.9k
Forks
610
Avg merge
2d 3h
Merged PRs (30d)
97

Description

### Feature Description

Feature Request: Option to Show Only Accessible Schemas for Current User

Currently, the extension lists all database schemas, even those the connected user does not have access to. This can be confusing and clutter the schema view, especially in environments with many schemas and limited user permissions.

Request:
Add an option (e.g., a setting or toggle) to filter and display only the schemas that the current user has access to, based on their permissions. This would help users focus on relevant objects and improve usability. For those who prefer to see all schemas, the default behavior can remain unchanged, with the filter as an opt-in feature.

Benefits:

Reduces clutter for users with limited permissions
Improves security awareness by showing only accessible objects
Makes schema navigation more efficient
Thank you for considering this enhancement!

### Problem and Motivation

Reduces clutter for users with limited permissions
Improves security awareness by showing only accessible objects
Makes schema navigation more efficient
Thank you for considering this enhancement!

### Related Area

- [x] Connection dialog
- [ ] Query results panel
- [ ] Query editor
- [ ] Object Explorer
- [ ] Table Designer
- [ ] Schema Compare
- [ ] Schema Designer
- [ ] Local container
- [ ] GitHub Copilot integration
- [ ] Query Plan Visualizer
- [ ] Other (please describe below)

### If you selected "Other", please describe the area

_No response_

### Confirmation

- [x] I have searched existing feature requests and couldn't find a match
- [ ] I want to help implement this feature

Contributor guide

No contributing guide indexed for this repository

Research direction

Start in the connection dialog area and locate how schemas are currently listed and how the connected user's permissions can be determined. Define an opt-in filter that shows only accessible schemas while preserving the existing default, then verify both filtered and unfiltered behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
typescript
Domain
authorization, database
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.