← Tutti gli articoli

AspNet Membership - TSQL Script to create a user and add it to a Role

17 ottobre 2012  · TSQL · Recipe  ·  213 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