Hi Shawn, and others,
We used Google's OpenID for login on our Gerrit, but some people accidentally use their @gmail for logging into our system which we do not prefer to keep that orphan account there.
I would like to remove all the user accounts which used by that particular domain (@
gmail.com in this case) in our DB, and also prevent them using it in the future. Is there a way to do these 2 tasks in Gerrit or we have to write our own SQL query for it?
Got this from my Google search on removing user account. Should I still follow this with the new Gerrit version?
"Deleting a user will orphan any comments or
review score the user has made. But if you are sure you want to remove
it, you can delete the record from accounts, account_ssh_public_keys,
account_external_ids, and account_group_members. If you want to keep
the account information but lock it to prevent login, remove the
records in account_ssh_public_keys and account_external_ids."
https://groups.google.com/forum/?fromgroups#!topic/repo-discuss/JlV0i9w5lCYAnd how do I prevent them in the future using "@
gmail.com" to login again.
Thanks.
Sam.