{"action":"opened","issue":{"url":"https://api.github.com/repos/metabase/metabase/issues/3466","repository_url":"https://api.github.com/repos/metabase/metabase","labels_url":"https://api.github.com/repos/metabase/metabase/issues/3466/labels{/name}","comments_url":"https://api.github.com/repos/metabase/metabase/issues/3466/comments","events_url":"https://api.github.com/repos/metabase/metabase/issues/3466/events","html_url":"https://github.com/metabase/metabase/issues/3466","id":181502768,"number":3466,"title":"In SQL editor, it's unclear which DB you're using if you only have SQL write access to one DB","user":{"login":"mazameli","id":2223916,"avatar_url":"https://avatars.githubusercontent.com/u/2223916?v=3","gravatar_id":"","url":"https://api.github.com/users/mazameli","html_url":"https://github.com/mazameli","followers_url":"https://api.github.com/users/mazameli/followers","following_url":"https://api.github.com/users/mazameli/following{/other_user}","gists_url":"https://api.github.com/users/mazameli/gists{/gist_id}","starred_url":"https://api.github.com/users/mazameli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mazameli/subscriptions","organizations_url":"https://api.github.com/users/mazameli/orgs","repos_url":"https://api.github.com/users/mazameli/repos","events_url":"https://api.github.com/users/mazameli/events{/privacy}","received_events_url":"https://api.github.com/users/mazameli/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/metabase/metabase/labels/Permissions","name":"Permissions","color":"954535"},{"url":"https://api.github.com/repos/metabase/metabase/labels/UX","name":"UX","color":"BBA8ED"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/metabase/metabase/milestones/22","html_url":"https://github.com/metabase/metabase/milestones/0.20.0","labels_url":"https://api.github.com/repos/metabase/metabase/milestones/22/labels","id":1866379,"number":22,"title":"0.20.0","description":"Code complete: Sept 29th","creator":{"login":"salsakran","id":107439,"avatar_url":"https://avatars.githubusercontent.com/u/107439?v=3","gravatar_id":"","url":"https://api.github.com/users/salsakran","html_url":"https://github.com/salsakran","followers_url":"https://api.github.com/users/salsakran/followers","following_url":"https://api.github.com/users/salsakran/following{/other_user}","gists_url":"https://api.github.com/users/salsakran/gists{/gist_id}","starred_url":"https://api.github.com/users/salsakran/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/salsakran/subscriptions","organizations_url":"https://api.github.com/users/salsakran/orgs","repos_url":"https://api.github.com/users/salsakran/repos","events_url":"https://api.github.com/users/salsakran/events{/privacy}","received_events_url":"https://api.github.com/users/salsakran/received_events","type":"User","site_admin":false},"open_issues":14,"closed_issues":177,"state":"open","created_at":"2016-07-05T23:55:43Z","updated_at":"2016-10-06T19:20:29Z","due_on":"2016-09-29T00:00:00Z","closed_at":null},"comments":0,"created_at":"2016-10-06T19:20:29Z","updated_at":"2016-10-06T19:20:29Z","closed_at":null,"body":"As @salsakran mentioned, if I have data permission for several DBs, but I only have SQL writing permission for **one** DB, I have no idea which DB I'm using when in SQL edit mode. This is because we currently special-case the scenario where there's only one usable DB, but now that the above scenario is possible due to permissions, this causes problematic ambiguity.\r\n\r\nI propose that instead, if I only have SQL writing permission for one database, we should still show the database dropdown in the top-left, but instead of being a dropdown it should be an unclickable static label, like this:\r\n\r\n![artboard](https://cloud.githubusercontent.com/assets/2223916/19167121/26bbec80-8bbf-11e6-815a-13f1c2b29c5b.png)\r\n\r\n"}}
{"actor":{"display_login":"mazameli"}}