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

[@wysheid2009]

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

[@abhay6276]

1000 likes needed to this channel.👍

[@wysheid2009]

Thanks for the good words 🙏

[@abhay6276]

@@wysheid2009 you are welcome sir....i would request please make such life changing videos as much as possible. thank you so much for quick response.

[@wysheid2009]

@@abhay6276 sure

[@philrine310]

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

[@wysheid2009]

Thanks Phil

[@debupaudel5219]

but i could update information from update command

[@SUDHIRSINGH-du4kq]

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

[@wysheid2009]

I have not tried in SQL server 2008..can you try the steps mentioned in this video and let me know the results

[@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

[@HansjeVdTillaert]

Would you be my friend?

[@wysheid2009]

Why not 😀

[@HansjeVdTillaert]

​@@wysheid2009 I was struggling to gave a sql user readonly acces. I tried this on instance level. On instance level you can set the database and member roles. But that didn't work. Luckely I find your very clear instructions and that works instantly, You have a new subscriber.