Need to get all the unique ID associated with security roles.

(0) Share

Report

Posted on by John Smith Sr.

420

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)

All responses (1)

Answers (0)

Suggested answer

André Arnaud de Cal... 301,119 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No