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

Vijay Kumar 2,016 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
0 comments No comments
{count} votes

Accepted answer
  1. Oury Ba-MSFT 16,076 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
  1. Michael Taylor 47,461 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.

    0 comments No comments