为Sql创建登录名 [英] Create Login For Sql

问题描述

我想在C#中使用linq并使用Create_New_User(我的用户名，我的密码)
添加新的登录名
当我运行以下代码时，通过@NewUserName和123密码创建新的登录名.
我想通过输入参数创建登录名.
怎么办?

Hi,i want using linq in c# and use Create_New_User(my username,my password)
to add new login
when i running following code creat new login by @NewUserName and 123 password.
i want create login by my input parameters.
how do this?

ALTER PROCEDURE [dbo].[Create_New_User]
(
@NewUserName VARCHAR(32),
@NewPassword NVARCHAR(8)
)

AS

SET NOCOUNT ON
CREATE LOGIN [@NewUserName] WITH PASSWORD ='123',
DEFAULT_DATABASE=[Kansar],
CHECK_EXPIRATION=OFF,
CHECK_POLICY=OFF

推荐答案

您调用proc并传递所需的参数.当然，将proc更改为使用您输入的新密码，而不是123.

您是在SQL Server还是代码中执行此操作?

You call the proc and pass in the parameters you want. Change the proc to USE the new password you pass in instead of 123, of course.

You''re doing this in SQL Server or in code ?

declare @userid varchar(50)='santhosh'
declare @password varchar(50)='kumartest123'

exec sp_addlogin @loginame = @userid,
		@passwd = @password,
		@defdb = 'Santhosh',
		@deflanguage = [British],
		@sid = null,		
		@encryptopt= null

Alter procedure sp_CreateLogin
      @name varchar(256),
      @password varchar(128)
as
   declare @sqlcmd varchar(2000);

   begin tran;
 

   set @sqlcmd = 'create login ' + quotename(@name) + '  with password = ' + quotename(@password, ''',check_policy=OFF');
   exec (@sqlcmd);
   if @@error <> 0
   begin
      rollback tran;
      print 'Cannot create login'
      return;
   end  
  
   commit tran;
go

exec sp_CreateLogin 'santhosh','kumar1222'

这篇关于为Sql创建登录名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！