How to Create Login User and Assign Permission to the user in SQL SERVER | MS SQL Server 2019
This session will help you understand the Step-by-Step MS SQL Server 2019 following concepts :
1.) How to create a Login
2.) How to create a User and associate a user with created login
3.) How to assign permission to the created user to access, update or delete database objects in a particular database.
LOGIN:
In the object, explorer goes to Security → Right-click on Logins → Select New login.
Enter Login name
In SQL Server authentication enter the password.
Then click on ok.
USER:
In object explorer expand databases.
Expand the database which you need to create the user.
Expand the security folder. Right-click on Users and select New User.
In the new pop-up window enter the User name and Login name after that click on ok.
ASSIGN PERMISSION: SQL Server allows GRANT, and REVOKE permissions.
For assigning permission go to the USER_SAMPLE property.
Click on the search option.
#sql ,
#sqlserver ,
#trainingonline .