web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / In which table can I f...
Microsoft Dynamics AX (Archived)

In which table can I find security role names and descriptions? (2012 R3)

(0) ShareShare
ReportReport
Posted on by Rossatron 27

Hi all,

Can anyone tell me in which table(s) the security role names and descriptions can be found?

I'm on AX2012 R3.

I'm assuming they link to the SECURITYROLE field in SECURITYUSERROLE but none of the tables with the column SECURITYROLE appear to hold the information I'm looking for.

Thanks in advance.

Ross.

*This post is locked for comments

I have the same question (0)
  • Rossatron Profile Picture
    Rossatron 27 on at

    I should probably mention that I want to write a SQL query to get to this data, so I need to know the table rather than any handy report that already exists.

    Thanks.

  • nmaenpaa Profile Picture
    nmaenpaa 101,166 Moderator on at

    This blog should help you: community.dynamics.com/.../ax2012-get-list-of-security-roles-with-name

  • Rossatron Profile Picture
    Rossatron 27 on at

    I have no table called SECURITYROLE so the SQL in that blog doesn't work.

    Thanks for trying though.

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,166 Moderator on at

    Are you sure? Did you check from AOT or SQL Server?  In AOT you find it in System Documentation - Tables.

    Thanks for trying :)

  • Rossatron Profile Picture
    Rossatron 27 on at

    In SQL. Got an invalid object error.

    I can be very trying. ;)

  • nmaenpaa Profile Picture
    nmaenpaa 101,166 Moderator on at

    You might need to mention the schema like dbo.SecurityRoles. Find the table from the tables list, right click, select top 1000 records (or something like that) will give you an example of the syntax.

    Do you have experience in querying AX database in SQL?

  • Rossatron Profile Picture
    Rossatron 27 on at

    I've been writing SQL for about 9 years, but only with AX for about 9 months. I'll keep plugging away at it. If you say it's definitely SECURITYROLE then it's SECURITYROLE. I'll find it.

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,166 Moderator on at

    You might need to look in the model database instead of business database.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 302,549 Super User 2025 Season 2 on at

    The last comment from Nikolaos is correct. It is a view or stored procedure in the ax model database.

  • Rossatron Profile Picture
    Rossatron 27 on at

    It transpires that because of a custom module we use, developed by an MS partner we used to work with, that table, and a number of others have been put into yet another db, not the business db or the model db.

    So you were absolutely right all along, we just have a horribly deformed system.

    Thanks for your help.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Volodya Profile Picture

Volodya 2

#2
tgudwanski Profile Picture

tgudwanski 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans