
Hey Guys,
As per my observation, SECURITYUSERROLE table contains the information of user and unique ID associated with security role. I have written a post on blog as well :
http://www.ax2012r3.com/blog/make-a-user-system-administrator-in-ax-from-sql-server
However, i need to know how can i get all the unique ID associated with security roles.
Please advice, I'm new bie
*This post is locked for comments
I have the same question (0)Hi John,
I have read your blog. Note that when you are unable to login with any user account, you can delete the SID and network alias fields in the Userinfo table.
The field RecId contains the ID for the role.
The first user which then opens AX will be added as Admin user. The ID for the system administrator role can be different per installation.
But can you clarify your question please? What do you mean with unique ID associated with security roles? Probably you are looking for the table SecurityRole? You can view the table using the SQL management studio or under AOT > System documentation > Tables