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.