{"action":"created","issue":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/1860","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/1860/labels{/name}","comments_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/1860/comments","events_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/1860/events","html_url":"https://github.com/cockroachdb/cockroach/issues/1860","id":98014902,"number":1860,"title":"sql: Add GRANT|REVOKE statements","user":{"login":"MBerhault","id":5901480,"avatar_url":"https://avatars.githubusercontent.com/u/5901480?v=3","gravatar_id":"","url":"https://api.github.com/users/MBerhault","html_url":"https://github.com/MBerhault","followers_url":"https://api.github.com/users/MBerhault/followers","following_url":"https://api.github.com/users/MBerhault/following{/other_user}","gists_url":"https://api.github.com/users/MBerhault/gists{/gist_id}","starred_url":"https://api.github.com/users/MBerhault/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MBerhault/subscriptions","organizations_url":"https://api.github.com/users/MBerhault/orgs","repos_url":"https://api.github.com/users/MBerhault/repos","events_url":"https://api.github.com/users/MBerhault/events{/privacy}","received_events_url":"https://api.github.com/users/MBerhault/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-07-29T19:44:59Z","updated_at":"2015-07-29T23:25:48Z","closed_at":null,"body":"This is the most user-friendly way to set privileges, and is needed for #1830 \r\n\r\nListing privileges is more annoying. postgres uses \\du, mysql uses \"show grant\". Most allow a table lookup on the privileges table.\r\n\r\nUntil we figure out where permissions go, we should do a special command (maybe similar do psql's \\du)."},"comment":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/comments/126126176","html_url":"https://github.com/cockroachdb/cockroach/issues/1860#issuecomment-126126176","issue_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/1860","id":126126176,"user":{"login":"MBerhault","id":5901480,"avatar_url":"https://avatars.githubusercontent.com/u/5901480?v=3","gravatar_id":"","url":"https://api.github.com/users/MBerhault","html_url":"https://github.com/MBerhault","followers_url":"https://api.github.com/users/MBerhault/followers","following_url":"https://api.github.com/users/MBerhault/following{/other_user}","gists_url":"https://api.github.com/users/MBerhault/gists{/gist_id}","starred_url":"https://api.github.com/users/MBerhault/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MBerhault/subscriptions","organizations_url":"https://api.github.com/users/MBerhault/orgs","repos_url":"https://api.github.com/users/MBerhault/repos","events_url":"https://api.github.com/users/MBerhault/events{/privacy}","received_events_url":"https://api.github.com/users/MBerhault/received_events","type":"User","site_admin":false},"created_at":"2015-07-29T23:25:48Z","updated_at":"2015-07-29T23:25:48Z","body":"oh yeah, there are a lot of various privileges, and even crazier levels they apply to. For the very first pass, I want to keep it simple: database-level read/write.\r\nEventually, we will most likely want some subset of the permissions (create, select, insert, update, delete). This is the kind of thing that isn't too complicated to add once the framework is in place."}}