I have a somewhat unusual problem. I have a local instance of Galaxy wherein
users are created automatically upon authentication (use_remote_user = True).
However, for a handful of users, their remote_user names have changed. After
that change, a new Galaxy user and role were created, and they can't access
their old data. Worse, they continued using the new account and so now have
two sets of (possibly) identical data.
Is there a simple way of migrating datasets, jobs, quotas, etc., from one user
I've figured out a way to make the necessary changes at the MySQL database
level. However, there is one sticky problem. None of the tables (aside from
role and galaxy_user) define the role_id or the user_id as unique, so I would
assume I can simply UPDATE the table to set the old role_id or user_id to the
new role_id or user_id. Unfortunately, it appears that some of the tables are
in practice keeping the role_id or user_id as unique. For example,
default_user_permissions or user_role_association. Could a single user have
multiple default permissions or multiple roles? What would happen if this were
In short, can anyone say which tables have practical unique role_id/user_id to
Of course, I could just delete the old user and say too bad...
Helix Systems Staff, CIT/NIH
Please keep all replies on the list by using "reply all"
in your mail client. To manage your subscriptions to this
and other Galaxy lists, please use the interface at: