Loading

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

anjali khan

10y928SQL

hi Frnds

I wants to know That how to restrict the user,no 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..

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Joginder Banger10y ago
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 Thakur10y ago
Hi,

Create a user who is only have access to view.
Dorababu Meka10y ago
Check this

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