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
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.
The last comment from Nikolaos is correct. It is a view or stored procedure in the ax model database.
You might need to look in the model database instead of business database.
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.
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?
In SQL. Got an invalid object error.
I can be very trying. ;)
Are you sure? Did you check from AOT or SQL Server? In AOT you find it in System Documentation - Tables.
Thanks for trying :)
I have no table called SECURITYROLE so the SQL in that blog doesn't work.
Thanks for trying though.
This blog should help you: community.dynamics.com/.../ax2012-get-list-of-security-roles-with-name
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.
André Arnaud de Cal...
292,074
Super User 2025 Season 1
Martin Dráb
230,900
Most Valuable Professional
nmaenpaa
101,156