ENG-6817: Enable CREATE ROLE via live DDL.  Add some basic testing.

-- Make an unclear error message a little less useless, see ENG-7185.
I don't know if the lexer regex needs more obnoxiously aggressive testing where the keywords are blended with other symbols, like "create role withpants with pockets" or "create role with pockets"...