New script to set up user on SQL Server

Herewith, I provide another script to set up a user in the SQL Server environment. The idea is that a role is created on the database. The user that is subsequently created is then added as a member to that role.

First, the login is created. It is created on the master database.

CREATE LOGIN kijker_Stagingzone WITH PASSWORD='****'
 GO
 CREATE USER kijker_Stagingzone FOR LOGIN kijker_Stagingzone  WITH DEFAULT_SCHEMA=[dbo]
 GO

Then the role is created on the database.

CREATE ROLE db_Kijken_Stagingzone AUTHORIZATION [dbo]
GO
GRANT 
    SELECT
ON SCHEMA::STAGINGZONE
    TO db_Kijken_Stagingzone
GO

Subsequently, a user is created and the user is added as a member to that role.

CREATE USER kijker_Stagingzone
    FOR LOGIN kijker_Stagingzone
    WITH DEFAULT_SCHEMA = STAGINGZONE
GO
EXEC sp_addrolemember N'db_Kijken_Stagingzone', N'kijker_Stagingzone'
GO

see for the latest addition:

use master

drop user edgar

CREATE LOGIN edgar WITH PASSWORD=”
GO
CREATE USER edgar FOR LOGIN edgar WITH DEFAULT_SCHEMA=[dbo]
GO

use sqlservertomvanmaanen
drop user edgar

CREATE USER edgar
FOR LOGIN edgar
WITH DEFAULT_SCHEMA = STAGINGZONE
GO
EXEC sp_addrolemember N’db_Lezer’, N’edgar’
GO