What's the most proper way to delete user account from Gerrit?

9,600 views
Skip to first unread message

Repo man

unread,
Jun 27, 2012, 2:59:23 PM6/27/12
to repo-d...@googlegroups.com
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/JlV0i9w5lCY


And how do I prevent them in the future using "@gmail.com" to login again.

Thanks.
Sam.

Deniz Türkoglu

unread,
Jun 27, 2012, 3:14:58 PM6/27/12
to Repo man, repo-d...@googlegroups.com
It is not in the release versions yet but there is a new command
called set-account that you can use to de-activate the accounts. You
can do the same via SQL, the field is in accounts table as column
'inactive'. This will prevent them from logging in and using the same
email in the future.

-deniz
> Thanks.
> Sam.
>
> --
> To unsubscribe, email repo-discuss...@googlegroups.com
> More info at http://groups.google.com/group/repo-discuss?hl=en
Reply all
Reply to author
Forward
0 new messages