@JD1016 - see my database guide book for Production Mapping, the best practices can be applied to any geodatabase in any industry, you will see how to setup the data owner user, the roles, and created editor and viewer users, and the editor/viewer users cannot create new featureclasses.
Best Practices Production Mapping 3.x Workspace in SQL Server®
Mapping and Charting Solutions (MCS) Enterprise Da... - Esri Community
In the link above you can also download my database tempate scripts for SQL Server, this includes the database guide book best practices and a lot more.
Note, editor / viewer users can still create geodatabase domains and featuredatasets, this is well known for a long time, and an enhancement request was submitted in the past, ENH-000152620, if possible, please you can open a ticket with esri tech support to request the same enhancement, if more customers ask for the enhancement, then it increases the changes for the enhancement to get implemented. There is nothing we can do in the SQL Server database in terms of privileges to prevent that, it is a change that needs to happen in the ArcGIS client software code.
I hope this helps.
| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov