It's a shame that the classic style separation of lexing and parsing means to support the command CREATE USER FOR LOGIN WITH means all of those are now magic keywords, instead of only behaving so in the context of a CREATE command.
As for how to name the "user" table, I've used "account". User is a human not a piece of data, Account is the data I have about their association with my service.