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
Advertisements
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
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!!!!
You can revoke SELECT permission from the tables for that particular users.