Azure SQL Database JSON text format issue with the roles

Lakshmipathi Kakarla 1 Reputation point
2021-03-18T14:17:40.597+00:00

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.

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: https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles

Azure SQL Database
{count} votes