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

Subscribe
Notify of
guest

0 Comments
Inline Feedbacks
View all comments