Prevent users from making changes to a database by making it read-only. Users cannot change any objects within a read-only database. You are required to provide a login name with rights to set database properties.
How to make a database read-only
1 In Servers and Databases, select a database.
2 Make the database available.
3 In the Navigation Pane, choose Database Tools➛Configure Database.
4 In Verify User Credentials, provide login credentials. Then, choose OK.
5 In Configure database, select Database is read only, as shown in Figure 10‑45. Choose Apply. In the confirmation message, choose OK.
