Created
July 7, 2014 18:23
-
-
Save cfalzone/0fcd84bb97d8a702d08f to your computer and use it in GitHub Desktop.
Updating a user role to match in all environments
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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