Johannes D (Jan 25 2024 at 12:06): Johannes D (Jan 25 2024 at 12:06):As an instance administrator, I want to change the email of a registered user. The user cannot login into the system (lost the password and access to the registered email). Whats the best/easiest way to do so? Is it save to update the value within the postgres DB?
Philip Durbin 🚀 (Jan 25 2024 at 12:30):There was some discussion about this here: SuperUser: grant ability to see and edit all user info and reset passwords (like we did in 3.6 as network admins) #2029
Philip Durbin 🚀 (Jan 25 2024 at 12:32):That was almost nine years ago.
Johannes D (Jan 25 2024 at 12:32):Thanks, do you think its OK to just alter the value via SQL? Or does this introduce some unforeseen side effects?
Philip Durbin 🚀 (Jan 25 2024 at 12:33):It should work. It's been a while since I tried.
Johannes D (Jan 25 2024 at 12:35):I trust you! I'll create a backup, change the value, hope for the best ;P
Philip Durbin 🚀 (Jan 25 2024 at 12:39):Do you think it should be a feature? Available via API?
Johannes D (Jan 25 2024 at 12:42):No, at least not for our use case. The root cause of the issue is related to changes not propagated to dataverse from the IdP. (https://github.com/IQSS/dataverse/issues/10266)
Philip Durbin 🚀 (Jan 25 2024 at 12:54):Right, that feature is only for Shibboleth users.
Philip Durbin 🚀 (Jan 25 2024 at 12:55):We changed the behavior when adding more remote types. Maybe we shouldn't have! :sweat_smile:
Johannes D (Jan 26 2024 at 07:36):I updated the table via SQL yesterday and there are no issues or side effect.
Last updated: Nov 01 2025 at 14:11 UTC