Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

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

(0) ShareShare
ReportReport
Posted on by 25

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

  • Rossatron Profile Picture
    Rossatron 25 on at
    RE: In which table can I find security role names and descriptions? (2012 R3)

    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.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,074 Super User 2025 Season 1 on at
    RE: In which table can I find security role names and descriptions? (2012 R3)

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

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: In which table can I find security role names and descriptions? (2012 R3)

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

  • Rossatron Profile Picture
    Rossatron 25 on at
    RE: In which table can I find security role names and descriptions? (2012 R3)

    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.

  • nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: In which table can I find security role names and descriptions? (2012 R3)

    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 25 on at
    RE: In which table can I find security role names and descriptions? (2012 R3)

    In SQL. Got an invalid object error.

    I can be very trying. ;)

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: In which table can I find security role names and descriptions? (2012 R3)

    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 25 on at
    RE: In which table can I find security role names and descriptions? (2012 R3)

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

    Thanks for trying though.

  • nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: In which table can I find security role names and descriptions? (2012 R3)

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

  • Rossatron Profile Picture
    Rossatron 25 on at
    RE: In which table can I find security role names and descriptions? (2012 R3)

    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.

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

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,074 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,900 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans