Guest User

Untitled

a guest
Dec 14th, 2018
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. UPDATE [dbo].[CMS_User]
  2. SET
  3. UserName=CONCAT('U',UserID),
  4. FirstName= CONCAT('U',UserID),
  5. MiddleName=NULL,
  6. LastName='Anoniem',
  7. FullName= CONCAT('U',UserID,' Anoniem'),
  8. Email=CONCAT('U',UserID,'@localhost'),
  9. UserPassword=CONVERT(NVARCHAR(32),HashBytes('SHA1', 'Super secret password'),2),
  10. UserPasswordFormat='SHA1'
  11. where UserName <> 'administrator'
  12. AND UserName<>'public'
  13. AND UserPrivilegeLevel<>3 -- skip global admins
Add Comment
Please, Sign In to add comment