User creation via script and sharing credentials

[sunilsargam]

hello Team,

I’ve created a custom table that extends the sys_user table. A user record is being generated under certain conditions via a Business Rule.

Once the user is created, I set a password programmatically and send the login credentials to the user via email.

While the password appears to be set successfully, when the user tries to log in through the ESC portal using the provided credentials, they receive an "Invalid credentials" error.

Has anyone encountered a similar issue or can offer guidance on this?

Thank you!

[GlideFather]

@sunilsargam or:
https://www.servicenow.com/docs/bundle/yokohama-platform-administration/page/administer/users-and-gr... 

[Chaitanya ILCR]

HI @sunilsargam ,

try this

to set the user password you have use the GlideElement setDisplayvalue Method

instead of gr.user_password = pass use gr.user_password.setDisplayvalue(pass)

var gr = new GlideRecord("customTable");
if (gr.get(userSysId)) {
    var pass = "test";
    gr.user_password.setDisplayValue(pass)
    gr.update();
}

this works but I just wanted to say this extending sys_user table is not recommended

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[Dr Atul G- LNG]

Hi @sunilsargam 

You need to set the password in the sys_user table manually.
Unless the password is set in that record, it will not work.

[sunilsargam]

Hi @Dr Atul G- LNG , 

Any workaround for this as i have to send it via email and want to do it using automation.

Thank you

[Dr Atul G- LNG]

Hi @sunilsargam 

The only thing needed is to create a password and pass it to the sys_user table.
From there, create a flow to send the password to the user.