How to permit a user to insert/update/delete data, but not alter schema in Azure SQL DB?

Question

How to permit a user to insert/update/delete data, but not alter schema in Azure SQL DB?

Answer 1

Hi @Vijay Kumar Thank you for posting your question on Microsoft Q&A and for using Azure services.

My understanding is that you are asking how to permit a user to permit a user to insert/update/delete data, but not alter schema in Azure SQL DB.

You could look up INSERT, UPDATE etc. permissions. You just need a user and GRANT INSERT ON SCHEMA:TheSchemaName TO UserX and then test.

Please let me know if that works.

Regards,
Oury

Answer 2

DML (data manipulation) commands like insert/update/delete are different than DDL (data definition) commands like create/alter/delete. Normal DB users do not have permissions to run DDL commands so you don't need to do anything other than ensuring that the users aren't dbos, admins, etc.