How to remove a role of a user in ignition with scripts

Ignition
,
1

I tried deleted role of a user via SQL query
delete from scada_user_rl where user_id =
( select id from scada_users where primaryEmail =:email )

but that did not work. I can add roles to a user using SQL query but cannot delete it.

Is it possible to delete it via scripts? If so, how would you go about doing that?

2

This is entirely untested, but it looks like you can get a User object with:

system.user.getUser(userSource,username)

Then from looking at this link you should be able to use this on that user object

removeRole('role')

so something like:

userToEdit = system.user.getUser(userSource,"username")
userToEdit.removeRole("role")

1 Like
3

You’d also need to save the user afterwards.

1 Like
4

Then as Kathy says, save it!

system.user.editUser(userSource, userToEdit)

2 Likes
5

This works for any user?

I can call any user and remove roles assigned to them