They both do the same thing and create a database user. The big difference (which may cause you some grey hair) is that
create roledoes not automatically allow log in.
So to create a database user for RHQ, use the
create userform. Example:
create user rhqadmin password 'rhqadmin'
If you have further login issues, see also my other posting about "local is not local"