Database read only but only few tables writable

Viewed 2880

I am trying to set the database as read only mode with the following command and it works.

ALTER DATABASE [TESTDB] SET READ_ONLY WITH NO_WAIT

However, I need to allow only few tables like UserSession, etc to be writable. Is it possible?

We have around 500+ tables in the database and we need to allow only 4 tables to be writable.

6 Answers
Related