[Feature Request]: Flat File Importer - Support for non-master users #21647
Description
Feature Description
When trying to run the flat file importer against a database that I'm connected to with a user that doesn't have access to master, it produces the following error:
Error running command mssql.flatFileImport: Microsoft.Data.SqlClient.SqlException (0x80131904): The server principal "UserNameRedactedForGithub" is not able to access the database "master" under the current security context. Cannot open database "master" requested by the login.
So its trying to connect specifically to the master DB, but this doesn't seem to be required in SQL Server Management Studio for it's equivalent to work as I can get that to work connected to the same database with the same user.
I believe it worked in Azure Data Studio as well, so it may already be in the pipeline.
Problem and Motivation
It would allow usage of the flat file importer for users that do not have access to master.
Related Area
- Connection dialog (SQL Server | Azure browse/Fabric browse)
- Query editor
- Query results panel
- Object Explorer
- GitHub Copilot integration
- Preview/Edit data
- Table Designer
- Schema Designer
- Schema Compare
- Local SQL Server Container provisioning
- SQL database in Fabric provisioning
- DACPAC/BACPAC export/import
- SQL Database projects
- Query Plan Visualizer
- Other (please describe below)
If you selected "Other", please describe the area
Flat File Importer
Confirmation
- I have searched existing feature requests and couldn't find a match
- I want to help implement this feature