how to restrict the userno one can change the data in sql ?

Question

hi Frnds I wants to know That how to restrict the userno one can change the data in sql db? how ? suppose i hv a database..in that user can access the data but canot change the data..

Joginder Banger · Answer

Hi Anjali Khan Am sure this help you... please check and let me know. http://www.joellipman.com/articles/microsoft/sql-server/create-read-only-database-user-in-sql-server.html

Pramod Thakur · Answer

Hi Create a user who is only have access to view.

Dorababu Meka · Answer

Check this http://www.joellipman.com/articles/microsoft/sql-server/create-read-only-database-user-in-sql-server.html

how to restrict the user,no one can change the data in sql ?