Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE [dbo].[CMS_User]
- SET
- UserName=CONCAT('U',UserID),
- FirstName= CONCAT('U',UserID),
- MiddleName=NULL,
- LastName='Anoniem',
- FullName= CONCAT('U',UserID,' Anoniem'),
- Email=CONCAT('U',UserID,'@localhost'),
- UserPassword=CONVERT(NVARCHAR(32),HashBytes('SHA1', 'Super secret password'),2),
- UserPasswordFormat='SHA1'
- where UserName <> 'administrator'
- AND UserName<>'public'
- AND UserPrivilegeLevel<>3 -- skip global admins
Add Comment
Please, Sign In to add comment