← Tutti gli articoli
AspNet Membership - TSQL Script to create a user and add it to a Role
17 October 2012 ·
TSQL · Recipe ·
205 visite
AspNet Membership - TSQL Script to create a user and add it to a Role
USE [DatabaseName] GO DECLARE @return_value int, @UserId uniqueidentifier, @ora datetime=getdate(), @username nvarchar(255), @eemail nvarchar(255); set @username= N'username'; set @eemail = N'username@name.com'; EXEC @return_value = [dbo].[aspnet_Membership_CreateUser] @ApplicationName = N'Cedolino', @UserName = @username, @Password = N'iniziale', @PasswordSalt= N'', @Email = @eemail, @IsApproved = 1, @CurrentTimeUtc = @ora, @CreateDate = @ora, @UniqueEmail = 0, @PasswordFormat = 0, @PasswordQuestion=N'', @PasswordAnswer=N'', @UserId = @UserId OUTPUT SELECT @UserId as N'@UserId' SELECT 'Return Value' = @return_value EXEC @return_value = [dbo].[aspnet_UsersInRoles_AddUsersToRoles] @ApplicationName = N'Cedolino', @UserNames = @username, @RoleNames = N'RoleName', @CurrentTimeUtc = @ora GO