sys_user_grmember records with empty user and empty role get added when activating the Agile Development 2.0 plugin.


Steps to Reproduce


Issue 1:
1) Deploy a new OOB instance.
2) Remove some OOB demo data users, specially those with the admin role.
3) Activate the plugin Agile Development 2.0 selecting the option 'Load demo data'.

This will add admin roles to all the deleted users also, which can be seen in sys_user_has_role table, showing the 'user' field empty, but with the sys_id's of deleted users.

Issue 2:
1) Deploy a new OOB instance.
2) Remove an OOB demo data user, for example Eric Schroeder.
3) Create a new user with the same first and last name but different user_id. Do not add any roles to this new user.
4) Activate the plugin Agile Development 2.0 loading demo data as well.

This will add all the roles, including admin, of the old demo data user "Eric Schroeder" to the newly created user with the same name. If any user has the same name as the demo data user, this will gets all the roles of the demo data user.


After carefully considering the severity and frequency of the issue, and the cost and risk of attempting a fix, it has been decided to not address this issue in any current or near future releases. We do not make these decisions lightly, and we apologize for any inconvenience. 

Demo data is intended to be loaded with an out of the box base configuration, to have basic users and groups to start with on an instance that is just deployed. Demo data is meant to be used only for demonstration purposes, and it is not recommended to be installed on production instances, to avoid colliding with custom product configurations.


Related Problem: PRB1272818

Seen In

There is no data to report.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-05-21 11:37:20