Wanted to rename a released product. Able to do from sysadmin role, but was not able to do from product designer and product design manager roles. These two are standard roles. Does Microsoft mean that this renaming can be done using sysadmin role only? Generally we don’t assign the sysadmin role to users. Users who have access to product designer and product design manager cannot rename part code? Do they need to rely on sysadmin? Or did I missed anything.
By the way, the error it was throwing to user is:
User ‘XXXX’ is not authorised to update a record in table ‘SIGPRODSTATUSCHANGE’. Request denied.
Cannot edit a record in Production order status change (SIGProdStatusChange). Access Denied: You do not have sufficient authorisation to modify data in database.
The security roles are simply examples, you need to create your own and add rights where you want them. Microsoft have given generic examples, that is all, if you disagree you alter them (most alter them to reflect the business)
Renaming a primary key is a bigger task that it may look. It must find and update all records across the whole AX that refers to the old ID (old item ID in your case). SIGProdStatusChange is just one of many tables that need to be updated.
Obviously, it’s not just a security issue - the process can also have performance implications and it will surely lock database resources, which may have impact to other users. Therefore I would actually recommend leaving such things to power users and doing them out of business hours.
Note that tables based on a surrogate key (introduced in AX2012) don’t have this problem, because the primary key never changes; only alternate keys are updated.