How to Add New User Login with Read Only Access to SQL Server | Create Login for SQL Server 2022

#SQLServerManagementStudio #sqlserver #sqlinterviewquestions
#SQLServerManagementStudio #SQLServer2022 #starsintech
Hello Friends,
In this video, I explain about the How to Create /Add new User Login for Database Using SQL Server Management Studio.(SSMS)
If you Like the Video Please Share and Subscribe to the My Channel.
/ @starsinfotch

Playlists:
• MS SQL Servers Tutorials.
Thank You.
Stars InfoTech

Chapters
00:00 Introduction to Topic.
00:24 Log in to SSMS.
01:05 Security section.
01:40 General and Server Roles Tab.
02:28 User Mapping and Status .
04:27 Login With New UserID
04:38 Validate the Permissions
05:32 End

Create read only database user in SQL Server 2022
1. Log in to Microsoft SQL Server Management Studio.
2. Go to Logins under the Security section.
Right-click on Logins and select New Login to create a new account. Click
3. General Tab - Select a page menu then, fill in the following fields.
a. Login name - Set a unique login name. Example: ReadOnlyUser
b. Select SQL Server authentication.

4 : Server Roles : Public
5. User Mapping : a. Select Database an Schemas for User.
b. Select Database Memberships db_Datareader
6. Securable : Select Serve Name
7. Status : a. Permission for Connect to Database Engine - grant
b. Login : Enable
8. Click Ok and Check the Login

#ssms #sqlserver2022 #sqlserver #sqlforbeginners #sqlinterviewquestions #sqltraining #datascience #viralvideo #jobinterview #education #tricks #Howto #howtomake

/ @starsinfotch
https://learn.microsoft.com/en-us/sql...