setup user in the database using SQL

Hi,

 

I have an important list of user to create in HDP with the same "profile" (set of roles, custom authentication, ...).

 

I looked at the elements to store in HDP database to setup a user and things look "easy" to do in SQL except on single elements.

 

A user profile requires a record in authentication table, containing a "hashed" password. Is it possible to know how to make such password ?

 

thanks,