<div>
A database in read only mode would be readable by users, but they would not be able to make changes. Naturally, their access would be controlled by permissions on the database. <a href="https://www.mssqltips.com/sqlservertip/1921/best-practices-for-working-with-read-only-databases-in-sql-server/" rel="ugc">This page</a> describes more about read only databases and may help.
</div>


A database in read only mode would be readable by users, but they would not be able to make changes. Naturally, their access would be controlled by permissions on the database. This page [https://www.mssqltips.com/sqlservertip/1921/best-practices-for-working-with-read-only-databases-in-sql-server/] describes more about read only databases and may help.

<div>
I would really appreciate some constructive feedback as to how Vitor's answer materially differs from what I said, a day earlier, and how it impoves it. Changes to a database would be DDL (creating, <i>modifying or removing</i> objects) or DML that modifies the data in the database (inserts, updates or deletes). Vitor's comment is technically incomplete.
</div>


I would really appreciate some constructive feedback as to how Vitor's answer materially differs from what I said, a day earlier, and how it impoves it. Changes to a database would be DDL (creating, modifying or removing objects) or DML that modifies the data in the database (inserts, updates or deletes). Vitor's comment is technically incomplete.

<div>
<div class="content wysiwyg-content">
If DB in Read-Only mode, can users access database. This is SQL Server 2008 just stanalone.
</div>
</div>


If DB in Read-Only mode, can users access database. This is SQL Server 2008 just stanalone.

SQL DB in Read-Only Mode

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.