Update imsma user: Difference between revisions
Jump to navigation
Jump to search
Created page with "If the imsma user has been set to inactive <pre> UPDATE "user" SET isactive = 't' WHERE userid = 'imsma' </pre> If you need to set the password to ''password'' <pre> UPDATE..." |
No edit summary |
||
| Line 1: | Line 1: | ||
{{Note | The syntax below is PostgreSQL.}} | |||
If the imsma user has been set to inactive | If the imsma user has been set to inactive | ||
<pre> | <pre> | ||
| Line 8: | Line 9: | ||
<pre> | <pre> | ||
UPDATE "user" | UPDATE "user" | ||
SET password = '5f4dcc3b5aa765d61d8327deb882cf99' | |||
WHERE userid = 'imsma' | |||
</pre> | |||
{{Note | The syntax below is MySQL.}} | |||
If the imsma user has been set to inactive | |||
<pre> | |||
UPDATE user | |||
SET isactive = 1 WHERE userid = 'imsma' | |||
</pre> | |||
If you need to set the password to ''password'' | |||
<pre> | |||
UPDATE user | |||
SET password = '5f4dcc3b5aa765d61d8327deb882cf99' | SET password = '5f4dcc3b5aa765d61d8327deb882cf99' | ||
WHERE userid = 'imsma' | WHERE userid = 'imsma' | ||
Latest revision as of 00:25, 26 October 2014
 |
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'