Seitenhistorie
...
Alle Passwörter zurücksetzen
| Codeblock | ||
|---|---|---|
| ||
update <schema>.t_md_user set strpassword = null, BLNLOCKED = 0, INTLOGINATTEMPTS = 0 |
User nuclos zum Superuser machen
| Codeblock | ||||
|---|---|---|---|---|
| ||||
update <schema>.t_md_user set BLNSUPERUSER = 1 where STRUSER = 'nuclos' |
Nuclos User anlegen (falls User Tabelle komplett leer)
| Codeblock |
|---|
insert into <schema>.t_md_user (struser, struid, intversion, blnsuperuser, strfirstname, strlastname, datcreated, strcreated, datchanged, strchanged)
values ('nuclos', 'kskjsiunzaoahng', 1, true, 'the', 'master', '2014-06-01', 'nuclos', '2014-06-01', 'nuclos') |
...
Überblick
Inhalte