From time to time i read articles such as here which suggest to use a unity catalog schema management tool. All table schema changes should be applied via this tool.
Usually SPs (or users) have the "Modify" Permission on tables. This allows to them to "update/insert/delete" some data and hence they need it. However, it also allows to update the schema (e.g. add new columns). Hence, such a schema managed tool can be easily bypassed right? I know there are options such as mergeSchema but at the end the visison of "all schema changes can only be done via a schema management tool" is not feasible as long as users have the modify permission.
