Azure SQL Database JSON text format issue with the roles

Lakshmipathi Kakarla 1 Reputation point

Hi team,

I created a user from EXTERNAL_RPOVIDER (AD) and assigned db_datareader & db_datawriter roles to same user in Azure SQL Database. When I execute a procedure with INSERT/UPDATE/DELETE statements with same user, I am getting below error.

JSON text is not properly formatted. Unexpected character 'x' is found at position 0. (13609) (SQLExecDirectW)

But if I assign db_owner role to same user, the SQL procedure executes successfully. I am not able to figure out the cause for this behavior. I want to limit the privileges granted to the user. What else I need to grant along with db_datareader & db_datawriter roles to fix this issue. Please advise.

DB Roles:

Azure SQL Database
{count} votes