Habeeb556 commented on issue #31183:
URL: https://github.com/apache/superset/issues/31183#issuecomment-2525557400

   @betodealmeida, I have another inquiry also regarding this. Previously 
`4.0.1` when I select for example `select * from 
database_name.schema_name.table_name` it was working fine.
   
   I applied the fix but still cannot select with database_name access denied. 
I required to grant full access `id:` to do that which wasnt before.
   
   
![image](https://github.com/user-attachments/assets/e23f89f7-2e25-41ff-b030-5badeb6c0a47)
   
   ```
   Dec  8 11:26:10 ef-extsuperset superset[3696623]: 2024-12-08 
11:26:10,802:DEBUG:superset.sql_parse:Parsing with sqlparse statement: select * 
from abcm.dbo.temp ;
   Dec  8 11:26:10 ef-extsuperset superset[3696623]: 2024-12-08 
11:26:10,816:DEBUG:superset.stats_logger:#033[36m[stats_logger] (incr) 
SqlLabRestApi.execute_sql_query.error#033[0m
   Dec  8 11:26:10 ef-extsuperset superset[3696623]: 2024-12-08 
11:26:10,816:DEBUG:superset.stats_logger:#033[36m[stats_logger] (timing) 
SqlLabRestApi.execute_sql_query.time | 122.99154791980982 #033[0m
   Dec  8 11:26:11 ef-extsuperset superset[3696616]: 2024-12-08 
11:26:11,842:DEBUG:superset.stats_logger:#033[36m[stats_logger] (incr) 
log#033[0m
   ```
   but I am able to select with dbo only:
   
   
![image](https://github.com/user-attachments/assets/41bafd0a-1208-4bc1-b15f-231c1f89c818)
   
   This needed for databases I have in the same instance and calling each other.


-- 
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]

Reply via email to