Hi there!
As a SQL begginer, I have a basic question about creating user:
If run the following script in Management Studio:
-------------------------------------------
:setvar DatabaseName "Application2"
:setvar DatabaseUserName "Oric123"
:setvar DatabaseUserPassword "127854*!"
GO
USE [$(DatabaseName)]
DECLARE @usercount int
SELECT @usercount=COUNT(name) FROM sys.database_principals WHERE name = '$(DatabaseUserName)'
IF @usercount = 0
CREATE USER $(DatabaseUserName) FOR LOGIN $(DatabaseUserName)
GO
EXEC sp_addrolemember db_datareader, $(DatabaseUserName)
EXEC sp_addrolemember db_datawriter, $(DatabaseUserName)
EXEC sp_addrolemember aspnet_Membership_FullAccess, $(DatabaseUserName)
EXEC sp_addrolemember aspnet_Roles_FullAccess, $(DatabaseUserName)
EXEC sp_addrolemember aspnet_Profile_FullAccess, $(Dat ...
Go to the complete details ...