Skip to content

Instantly share code, notes, and snippets.

@cfalzone
Created July 7, 2014 18:23
Show Gist options
  • Select an option

  • Save cfalzone/0fcd84bb97d8a702d08f to your computer and use it in GitHub Desktop.

Select an option

Save cfalzone/0fcd84bb97d8a702d08f to your computer and use it in GitHub Desktop.
Updating a user role to match in all environments
select * from users_cms_roles where user_id = 'dotcms.org.2838';
-- note the id and change the id in the example on line 10
delete from users_cms_roles where user_id = 'dotcms.org.2838';
update cms_role set db_fqn = '9ac1ff78-71a9-4485-a541-9d1418b17aa4 --> 8f0c52ca-6215-4fd4-a62d-992998cdab51' where role_key = 'dotcms.org.2838';
update cms_role set id='8f0c52ca-6215-4fd4-a62d-992998cc12f2' where role_key = 'dotcms.org.2838';
-- Make sure to note the id from line 1 and change it to the correct id instead of ed155bc3-beb6-4ebe-81bc-9d077dfd8320
insert into users_cms_roles values ('ed155bc3-beb6-4ebe-81bc-9d077dfd8320','dotcms.org.2838','8f0c52ca-6215-4fd4-a62d-992998cc12f2');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment