{"action":"created","issue":{"url":"https://api.github.com/repos/chucknorris/roundhouse/issues/188","labels_url":"https://api.github.com/repos/chucknorris/roundhouse/issues/188/labels{/name}","comments_url":"https://api.github.com/repos/chucknorris/roundhouse/issues/188/comments","events_url":"https://api.github.com/repos/chucknorris/roundhouse/issues/188/events","html_url":"https://github.com/chucknorris/roundhouse/issues/188","id":73932751,"number":188,"title":"Permissions not being granted","user":{"login":"ashic","id":565991,"avatar_url":"https://avatars.githubusercontent.com/u/565991?v=3","gravatar_id":"","url":"https://api.github.com/users/ashic","html_url":"https://github.com/ashic","followers_url":"https://api.github.com/users/ashic/followers","following_url":"https://api.github.com/users/ashic/following{/other_user}","gists_url":"https://api.github.com/users/ashic/gists{/gist_id}","starred_url":"https://api.github.com/users/ashic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ashic/subscriptions","organizations_url":"https://api.github.com/users/ashic/orgs","repos_url":"https://api.github.com/users/ashic/repos","events_url":"https://api.github.com/users/ashic/events{/privacy}","received_events_url":"https://api.github.com/users/ashic/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-05-07T10:26:10Z","updated_at":"2015-05-07T12:03:03Z","closed_at":null,"body":"Hi,\r\nI've got a weird issue around granting permissions. It seems that the same roundhouse scripts targeting my local machine work fine (i.e. db created, permissions assigned), but when targeting some remote machines, the db and tables are created, but no permissions are assigned. I've treble checked that Roundhouse IS running the permissions files, and it's all green (no errors) - the permissions simply aren't granted.\r\n\r\nIf I copy - paste the script into mgmt studio running under the same account (Integrated Security), then the permissions ARE assigned. If I run the file from sqlcmd targeting the remote databases, the permissions ARE granted.\r\n\r\nAt this point, my guess is that some policy on the remote dbs prevent applications from updating permissions. Otherwise, using the same credentials and connection strings, I'd expect the permissions to work.\r\n\r\nDoes anybody have any ideas as to why mgmt studio + sqlcmd would work, but roundhouse wouldn't?"},"comment":{"url":"https://api.github.com/repos/chucknorris/roundhouse/issues/comments/99834126","html_url":"https://github.com/chucknorris/roundhouse/issues/188#issuecomment-99834126","issue_url":"https://api.github.com/repos/chucknorris/roundhouse/issues/188","id":99834126,"user":{"login":"ferventcoder","id":63502,"avatar_url":"https://avatars.githubusercontent.com/u/63502?v=3","gravatar_id":"","url":"https://api.github.com/users/ferventcoder","html_url":"https://github.com/ferventcoder","followers_url":"https://api.github.com/users/ferventcoder/followers","following_url":"https://api.github.com/users/ferventcoder/following{/other_user}","gists_url":"https://api.github.com/users/ferventcoder/gists{/gist_id}","starred_url":"https://api.github.com/users/ferventcoder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ferventcoder/subscriptions","organizations_url":"https://api.github.com/users/ferventcoder/orgs","repos_url":"https://api.github.com/users/ferventcoder/repos","events_url":"https://api.github.com/users/ferventcoder/events{/privacy}","received_events_url":"https://api.github.com/users/ferventcoder/received_events","type":"User","site_admin":false},"created_at":"2015-05-07T12:03:03Z","updated_at":"2015-05-07T12:03:03Z","body":"Never ran into this issue and we extensively used the permissions against a non-local db."}}