1. Dieses Beispiel zeigt wie man das Passwort eines Users in DotNetNuke via
SQL zurücksetzen kann.
ALTER procedure dbo.uap_ResetPassword
@UserName NVarChar(255),
@NewPassword NVarChar(255)
AS
BEGIN
DECLARE @PasswordSalt NVarChar(128)
DECLARE @ApplicationID NVarChar(255)
DECLARE @ApplicationName NVarChar(255)
SET @ApplicationID = (SELECT ApplicationID FROM aspnet_Users WHERE UserName=@UserName)
SET @ApplicationName = (SELECT ApplicationName FROM aspnet_Applications WHERE ApplicationID=@ApplicationID)
SET @PasswordSalt = (SELECT PasswordSalt FROM aspnet_Membership WHERE UserID IN (SELECT UserID FROM aspnet_Users WHERE UserName=@UserName))
–SELECT @ApplicationID, @ApplicationName
DECLARE @RetVal as int
EXEC @RetVal = dbo.aspnet_Membership_ResetPassword @ApplicationName, @UserName, @NewPassword, 10, 10, @PasswordSalt, -5
RETURN @RetVal
END