Hilbert Solutions, LLC | Blog About DotNetNuke - Delete Users in Dotnetnuke with MPUSX Support

Delete Users in Dotnetnuke with MPUSX Support

Aug8

Written by:slhilbert
8/8/2008 10:00 AM

Here is a stored procedure you can use to delete users from Dotnetnuke. This also has a procedure to remove a user from DNN Master's multi-portal sharing. It won't hurt anything if you leave it in there.

To delete the user just call DeleteUserByUserName 'SomeUserName'

ANSI_NULLSONQUOTED_IDENTIFIERON

Create

@Username

procedure [dbo].[DeleteUserByUserName]asnvarchar(100)

EXEC

aspNet_Users_DeleteUser 'DotNetNuke', @Username, 15, 0deletefrom Users

Where

Username = @Username

delete

from DNNMasters_MPUS_X_UserInSharedArea

WHERE

Username =@Username

set

Trackback Print

Tags:

Categories:

Location: Blogs Parent Separator

Hilbert Solutions, LLC

0 comment(s) so far...

Your name:
Your email:
	(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:

Security Code Enter the code shown above in the box below
Add Comment Cancel