MS SQL – Creating a user with full permissions to the database

Create the user "admin_web" with the username "admin_web", password "password1234" and provide the owner permissions to the database "artem_services"

Create LOGIN:

CREATE LOGIN admin_web with Password ='password1234';
GO

Use necessary database:

USE artem_services;
GO

Create a USER for the previously created LOGIN:

CREATE USER admin_web FOR LOGIN admin_web;
GO

Add a USER to the database owners group:

ALTER ROLE db_owner ADD MEMBER admin_web;
GO

Tagged: Tags MS SQL sqlcmd