[GitHub] [superset] betodealmeida edited a comment on pull request #18064: feat: datasource access to allow more granular access to tables on SQL Lab

[GitBox <gi...@apache.org>]

betodealmeida edited a comment on pull request #18064:
URL: https://github.com/apache/superset/pull/18064#issuecomment-1016736387


   I created a test user `sqllab` in the ephemeral environment above (password `sqllab`) and assigned it to the role `sql_lab`, and assigned the permission `datasource access on [examples].[messages](id:10)` to that role.
   
   But I wasn't able to query the table:
   
   ```sql
   SELECT * FROM examples.messages
   ```
   
   On the browser console I can see the error:
   
   ```json
   {
     "errors": [
       {
         "message": "You need access to the following tables: `examples.messages`,\n            `all_database_access` or `all_datasource_access` permission",
         "error_type": "TABLE_SECURITY_ACCESS_ERROR",
         "extra": {
           "link": "",
           "tables": [
             "examples.messages"
           ]
         }
       }
     ]
   }
   ```
   
   Maybe @dpgaspar can shed some light here?


-- 
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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org