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

Vijay Kumar 1,936 Reputation points
2022-08-12T19:37:05.56+00:00

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

Azure SQL Database
Accepted answer
  1. Oury Ba-MSFT 10,171 Reputation points Microsoft Employee
    2022-09-13T16:57:53.407+00:00

    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

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Michael Taylor 40,921 Reputation points
    2022-08-12T20:17:24.69+00:00

    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.