{"action":"created","issue":{"url":"https://api.github.com/repos/CartoDB/CartoDB-SQL-API/issues/230","labels_url":"https://api.github.com/repos/CartoDB/CartoDB-SQL-API/issues/230/labels{/name}","comments_url":"https://api.github.com/repos/CartoDB/CartoDB-SQL-API/issues/230/comments","events_url":"https://api.github.com/repos/CartoDB/CartoDB-SQL-API/issues/230/events","html_url":"https://github.com/CartoDB/CartoDB-SQL-API/issues/230","id":86559193,"number":230,"title":"Inserting in shared tables fails because of sequence permission","user":{"login":"juanignaciosl","id":932968,"avatar_url":"https://avatars.githubusercontent.com/u/932968?v=3","gravatar_id":"","url":"https://api.github.com/users/juanignaciosl","html_url":"https://github.com/juanignaciosl","followers_url":"https://api.github.com/users/juanignaciosl/followers","following_url":"https://api.github.com/users/juanignaciosl/following{/other_user}","gists_url":"https://api.github.com/users/juanignaciosl/gists{/gist_id}","starred_url":"https://api.github.com/users/juanignaciosl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juanignaciosl/subscriptions","organizations_url":"https://api.github.com/users/juanignaciosl/orgs","repos_url":"https://api.github.com/users/juanignaciosl/repos","events_url":"https://api.github.com/users/juanignaciosl/events{/privacy}","received_events_url":"https://api.github.com/users/juanignaciosl/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-06-09T11:16:11Z","updated_at":"2015-06-17T09:11:18Z","closed_at":null,"body":"I can add rows in this table through the editor, but not with the SQL API:\r\n\r\n```\r\n➜  ~  curl -d \"api_key=<myapikey>&q=insert into rtorre.csv_3 (kkk) values ('Japan')\" https://juanignaciosl.cartodb.com/api/v2/sql\r\n{\"error\":[\"permission denied for sequence csv_3_cartodb_id_seq\"]}%\r\n```\r\n\r\n*I report it here for @rochoa to take a look, but it probably involves a fix in CartoDB backend organization user creation*"},"comment":{"url":"https://api.github.com/repos/CartoDB/CartoDB-SQL-API/issues/comments/112730893","html_url":"https://github.com/CartoDB/CartoDB-SQL-API/issues/230#issuecomment-112730893","issue_url":"https://api.github.com/repos/CartoDB/CartoDB-SQL-API/issues/230","id":112730893,"user":{"login":"juanignaciosl","id":932968,"avatar_url":"https://avatars.githubusercontent.com/u/932968?v=3","gravatar_id":"","url":"https://api.github.com/users/juanignaciosl","html_url":"https://github.com/juanignaciosl","followers_url":"https://api.github.com/users/juanignaciosl/followers","following_url":"https://api.github.com/users/juanignaciosl/following{/other_user}","gists_url":"https://api.github.com/users/juanignaciosl/gists{/gist_id}","starred_url":"https://api.github.com/users/juanignaciosl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juanignaciosl/subscriptions","organizations_url":"https://api.github.com/users/juanignaciosl/orgs","repos_url":"https://api.github.com/users/juanignaciosl/repos","events_url":"https://api.github.com/users/juanignaciosl/events{/privacy}","received_events_url":"https://api.github.com/users/juanignaciosl/received_events","type":"User","site_admin":false},"created_at":"2015-06-17T09:11:18Z","updated_at":"2015-06-17T09:11:18Z","body":"In the editor [table owner role is used](https://github.com/CartoDB/cartodb/blob/master/app/models/table.rb#L883)."}}