Not possible to create two authorization rules (for structure and data management) for the same user in the same space
As suggested during the Practice PM meeting, I tried to add the second authorization rule for the user Bo Werth who has already a 1315 (DataImporterRole) premission in OECD-design space to allow management of structural artefacts.
The current user's right:
{
"id": 41,
"userMask": "bo.werth@gmail.com",
"isGroup": false,
"dataSpace": "OECD-design",
"artefactType": 0,
"artefactAgencyId": "*",
"artefactId": "*",
"artefactVersion": "*",
"permission": 1315
}
Submission of the additional user right fails:
{
"id": 0,
"userMask": "bo.werth@gmail.com",
"isGroup": false,
"dataSpace": "OECD-design",
"artefactType": 0,
"artefactAgencyId": "*",
"artefactId": "*",
"artefactVersion": "*",
"permission": 657
}
{
"Payload": {
"Errors": [
"Cannot insert duplicate key row in object 'dbo.AUTHORIZATIONRULES' with unique index 'U_AUTHORIZATIONRULES'. The duplicate key value is (bo.werth@gmail.com, 0, OECD-design, 0, *, *, *).\nThe statement has been terminated."
]
Should there be a new user role "1972" to combine both these rights? Or should two user rights be allowed for the user in the same space?