create read only database user in SQL Server 2019 in 3 steps

In this tutorial, we will demonstrate how to create a read-only database in SQL Server.
We will be performing these 3 steps
1) Create database user

2) Grant the read-only database role to the user
3) Check if the user can see the tables of different schemas

[wysheid]

Hello All, In this tutorial, we are demonstrating the steps to create a read-only database user in SQL Server 2019. The steps are applicable for previous versions of SQL Server as well. Please subscribe, comment and share if you like this video

[philrine]

Excellent tutorial! I am well versed in SQL and you made it very clear how to accomplish this task.

[debupaudel]

but i could update information from update command

[knuif]

If you are trying to connect using SQL Server Authentication, verify that SQL Server is configured in Mixed Authentication Mode. For more information on changing SQL Server authentication mode review Change server authentication mode

[SUDHIRSINGH-dukq]

Sir, it can help in sql server 2008 or not??