SQL DB in Read-Only Mode

If DB in Read-Only mode, can users access database. This is SQL Server 2008 just stanalone.
Who is Participating?
Vitor MontalvãoMSSQL Senior EngineerCommented:
Sure, they can but mind that being in Read-Only mode they can't perform any write operation (INSERT, DELETE, UPDATE) neither create objects.
Martyn SpencerConsultantCommented:
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 describes more about read only databases and may help.
VijayAuthor Commented:
Thank you very much Vitor
Martyn SpencerConsultantCommented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.