Read Only Access for SQL Server

We recently had a snafu when the on-call developer ran an update statement on a production Azure SQL database when it should have been a select statement. Luckily we were able to restore the proper values based off other tables or worst-case scenari...