← 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



Si è verificato un errore imprevisto. Ricarica

Rejoining the server...

Rejoin failed... trying again in seconds.

Failed to rejoin.
Please retry or reload the page.

The session has been paused by the server.

Failed to resume the session.
Please retry or reload the page.