runes83 · January 29, 2020 10:17
diff --git a/Create sql user b/Create sql user
 # Master database:
 CREATE LOGIN SQLUSER
 	WITH PASSWORD = 'Password123' 
 GO

 # Service database:

 -- For login <login_name, sysname, login_name>, create a user in the database
 CREATE USER SQLUSER
 	FOR LOGIN SQLUSER


 -- Add user to the database owner role
 EXEC sp_addrolemember db_datareader, communicationSql
 EXEC sp_addrolemember db_datawriter, communicationSql
 GO
	# Master database:
	CREATE LOGIN SQLUSER
	WITH PASSWORD = 'Password123'
	GO

	# Service database:

	-- For login <login_name, sysname, login_name>, create a user in the database
	CREATE USER SQLUSER
	FOR LOGIN SQLUSER


	-- Add user to the database owner role
	EXEC sp_addrolemember db_datareader, communicationSql
	EXEC sp_addrolemember db_datawriter, communicationSql
	GO
No results found