How to make database read only?

You can use the below script to make the database read only so that no user can edit the database.

USE [master] GO ALTER DATABASE [DBName] SET READ_ONLY WITH NO_WAIT OR GO ALTER DATABASE [DBName] SET READ_ONLY GO

2 thoughts on “How to make database read only?”

kaushalpatel245 February 6, 2012 at 10:47 am

how to remove read only from some of the tables of my database in mysql ?

i dont know how this happened !!

help me to do solve as fast!!!!

Reply ↓

Jugal Shah Post authorFebruary 6, 2012 at 10:14 pm

You can revoke SELECT permission from the tables for that particular users.

Reply ↓

aiDeeva.com