I have made a copy of production environment and restored on development environment and deleted all the users from userinfo table.
I got an request to provide access to an user but whenever i tried to import new user i started getting error.
Cannot insert multiple records in Security user role (SecurityUserRole).
This error itself giving you solution of the problem,we have to delete the record from this table with USER_= “new user”.
Route cause: The route cause of this error is inconsistency between userinfo table and securityUserRole.
Solution: Open SQL Server Management Studio, SQL DB, Select the MicrosoftDynamicsAX database and run the below query
delete from dbo.SECURITYUSERROLE where USER_ = ‘deepakKal’
To check user details run:
select * from dbo.SECURITYUSERROLE.
Now if you will try again to add same user then you will see its added without any error.
Happy Daxing 🙂