Update imsma user

The syntax below is PostgreSQL.

If the imsma user has been set to inactive

UPDATE "user" 
SET isactive = 't'  WHERE userid = 'imsma'

If you need to set the password to password

UPDATE "user"
SET password = '5f4dcc3b5aa765d61d8327deb882cf99' 
WHERE userid = 'imsma'

The syntax below is MySQL.

If the imsma user has been set to inactive

UPDATE user 
SET isactive = 1  WHERE userid = 'imsma'

If you need to set the password to password

UPDATE user
SET password = '5f4dcc3b5aa765d61d8327deb882cf99' 
WHERE userid = 'imsma'

Template:NavBox Hub