Insert new users with script

[MoisesZV]

Hi, I want to insert new users and Roles when a client push a Button. I know I have to insert the username to “scada_users” and the role to scada_user_rl but when I tried to log in I received a login Failed error. The diference I can see is the password column have encrypted data and when I insert the password it’s not.

[JordanCClark]

This thread should help you out.

inductiveautomation.com/forum/v … md5#p53048

[MoisesZV]

Thanks Jordan, it works great!

[nminchin]

Hi Jordan, any chance you can relink this as it didn’t make it across from the forum upgrade

[JordanCClark]

I think it was this one...

Add Users and Roles in Event Script

Hi Adnan, You can do this if you set up your User Source with a type of Database, meaning that the user and role details are stored in a SQL database. You can then create a script to write directly to the correct tables: user details go in the auth_users table, roles in the auth_roles table and users are mapped to roles in the auth_user_rl table. The easiest thing to do is create a User Source with a type of Database and add a dummy user before looking at the tables to see how those details a…