This my table:
Create a unique index or constraint on however you identify the user. I'm not sure which columns you have in mind, but this would be typical:
alter table mytable add constraint unq_table_email unique (email);
You can have more than one unique constraint on the table.