Migrating security from 7.1 to 7.2

Support
#1

The migration from 7.1 project to 7.2 is successful and app.properties changed as per documentation to enforce new security system.
Project running perfectly but how to change the default user and roles in existing project database. (project run perfectly after creating new database, but i don’t want to loose data)

How to change the default user and roles after migrating to new security.

Thanks

#3

You can modify any of the roles with the database update scripts. You can create new roles, update existing roles, assign and remove permissions, etc.

For example, to assign a system-full-access role to admin you can use a script like this:

insert into SEC_USER_ROLE (ID, CREATE_TS, VERSION, USER_ID, ROLE_NAME)
values ('6736effb-9dfc-4430-973a-69868606b09c', current_timestamp, 0, '60885987-1b61-4247-94c7-dff348347f93', 'system-full-access');

And the last note, just in case: you don’t need to migrate to a new security model. If the old security model worked for you, you can stay with it, it will continue working.