microsoft / microsoft/vscode-mssql
[Feature Request]: Option to Show Only Accessible Schemas for Current User
- 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