Habeeb556 commented on issue #31406: URL: https://github.com/apache/superset/issues/31406#issuecomment-3128049490
> [@Habeeb556](https://github.com/Habeeb556) when you say this query fails: > > SELECT * FROM abcm.dbo.temp; > Can you clarify: > > 1. What roles/permissions the user has? > 2. What is the default catalog the connection is using (it should be in the SQLAlchemy URI, I think)? > > If the default catalog is something else than `abcm`, then to run the query above you would need one of these permissions (this is from memory, I could be wrong): > > * all database access > * all datasource access > * database access to the SQL Server DB > * catalog access to `abcm` > * schema access to `abcm.dbo` > * dataset access to `abcm.dbo.temp` > > If you don't have any of these permissions, then the query should fail. Yes, URI `mssql+pyodbc://SuperSet:XXXXXXXXXX@abcm` The permission was `schema access on [abcm].[dbo]` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
