is it save to delete an wrongly created account from database?

46 views
Skip to first unread message

Makson Lee

unread,
Jan 13, 2017, 2:41:38 AM1/13/17
to Repo and Gerrit Discussion
okay, i just created an wrong account, but there is no way to delete it, so is it save to remove it from database?

delete from accounts where account_id = '1000001';
delete from account_external_ids where account_id = '1000001';

RJ

unread,
Jan 13, 2017, 3:10:15 PM1/13/17
to Repo and Gerrit Discussion


you should be able to make the account ID inactive 


update accounts set inactive = 'Y' where account_id = '1000001';


Rj

Matthias Sohn

unread,
Jan 13, 2017, 5:56:52 PM1/13/17
to RJ, Repo and Gerrit Discussion
there is no need to do this on SQL level, instead use the set-account ssh command:

ssh -p <port> <host> gerrit set-account --inactive <USER>

--
--
To unsubscribe, email repo-discuss+unsubscribe@googlegroups.com
More info at http://groups.google.com/group/repo-discuss?hl=en

---
You received this message because you are subscribed to the Google Groups "Repo and Gerrit Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to repo-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Makson Lee

unread,
Jan 13, 2017, 8:19:07 PM1/13/17
to Repo and Gerrit Discussion, ravi....@broadcom.com
i know that we can inactive a user with ssh command, because it is a wrongly created account, so i just wonder if we can completely remove it from system, anyway, thanks for reply.


On Saturday, January 14, 2017 at 6:56:52 AM UTC+8, Matthias Sohn wrote:
there is no need to do this on SQL level, instead use the set-account ssh command:

ssh -p <port> <host> gerrit set-account --inactive <USER>

On Fri, Jan 13, 2017 at 9:10 PM, 'RJ' via Repo and Gerrit Discussion <repo-d...@googlegroups.com> wrote:


you should be able to make the account ID inactive 


update accounts set inactive = 'Y' where account_id = '1000001';


Rj


On Thursday, January 12, 2017 at 11:41:38 PM UTC-8, Makson Lee wrote:
okay, i just created an wrong account, but there is no way to delete it, so is it save to remove it from database?

delete from accounts where account_id = '1000001';
delete from account_external_ids where account_id = '1000001';

--
--
To unsubscribe, email repo-discuss...@googlegroups.com

More info at http://groups.google.com/group/repo-discuss?hl=en

---
You received this message because you are subscribed to the Google Groups "Repo and Gerrit Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to repo-discuss...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages