One option is to just not give them the permissions that
allow modifying objects. If they need something changed,
have them give you a script that you run. Require scripts
for everything.

-Sue

The best approach would be to remove CREATE object rights from the
developers.

Hi,

Direct answer is NO.

Otherway is restrict the previlages (Just give db_datareader and
db_datareader roles) to users

Thanks
Hari
SQL Server MVP