DotNetNuke - SQL Server Statements to Change User Password
|
--Get PasswordSalt & Password Format
SELECT * from aspnet_Membership
--Get User ID
SELECT * FROM Users
--Get Portal ID
SELECT * FROM PortalAlias
--Get Application Name
SELECT * FROM aspnet_Applications
--Change Password, RUN aspnet_Membership_SetPassword Stored Procedure
EXEC aspnet_Membership_SetPassword 'applicationname', 'username', 'newpassword', 'passwordsalt', 'passwordformat'
--Confirm
SELECT * from aspnet_Membership


Comments