Error - "ACL Exception Insert Failed due to security constraints"

[Praful5]

Hi 

I am trying to Automate change creation in service now with ansible through REST API. I am using the ansible uri module with POST method. I am getting the below error:

        "content": "{\"error\":{\"detail\":\"ACL Exception Insert Failed due to security constraints\",\"message\":\"Operation Failed\"},\"status\":\"failure\"}",

        "content_type": "application/json;charset=UTF-8",

        "json": {

            "error": {

                "detail": "ACL Exception Insert Failed due to security constraints",

                "message": "Operation Failed"

            },

            "status": "failure"

Could anyone can please help me ??

[Lukasz Bojara]

Hi,

What user is used when you try to insert new record? Check if this user has the correct role to be able to create new records in this table.

Best regards,
Łukasz

[Ankur Bawiskar · Accepted solution]

Hi,

there is a CREATE acl on that table that is blocking the operation.

with which user you are testing this? admin or non-admin

if non-admin does that user have create Access on that table

check the above details

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Praful5]

Thanks for your reply. I am using non admin user.

I had already discussed this with the people in my organization who support service now. I got a reply from them that the user account has already permission. Not sure why it does not work. What could be the other possibilities ??

[Praful5]

In fact, i am unable to see the roles which is assigned to the user. May be because the permission is not there. I see the user is part of 4 roles. But not able to see what are those roles