Skip to main content

User security role assignment report [AX 2012]

There isn’t a report that lists the users and their security roles. You can get this information fairly quickly through Excel add-in.

1. Go to the AOT and find the Query SysSecRolesForUser.

2. Duplicate it and remove the code (it has code in the init method to filter by current user).

Then just go the organization > “Document data sources”. Select your query and activate it.

3. In Excel select the service, select the fields and run.

You should see a nice list of user and their roles.



Anonymous said…
I have found success utilizing Arbela's Security Manager:
Anonymous said…
Hi. I am very inexperienced with this. can you add more detail? How do I modify the init? How do I connect MS Excel to a "Service"

May Thanks!!
Shao Kahn said…
Thank you i was new guy but got it thanks alot !
Unknown said…
how can I get system administration module in data document sources while selecting query
ERP said…
ERPTREE handles oracle fusion HCM training and its modules maintaining classroom based training with the self-paced videos. An expert having ten plus years of self-experience handles the training period through online and explains each and every point perfectly. We recently launched our institute in the USA and getting the best reputation over there.

Oracle Fusion HCM Training
Unknown said…

Can someone elaborate "Then just go the organization > “Document data sources”. Select your query and activate it. "

How do I find this "Document data sources? "

Many thanks in advance.
Thank you for sharing your awesome and valuable article this is the best blog for the students they can also learn.

Workday Online Training
Such a nice blog, I really like what you write in this blog, I also have some relevant Information about if you want more information.

Workday HCM Online Training
Thank you for sharing such a nice and interesting blog and really very helpful article

Workday Online Training
Very interesting blog Really excellent information and thank you for giving your valuable information

Oracle Fusion HCM Online Training
Good Information Thanks for Sharing
Soft Online Provides best online training for Oracle Fusion and EBS R12 Courses
Oracle EBS Training in Hyderabad
Oracle Fusion SCM Training in Hyderabad
Oracle Fusion HCM Training
Oracle Fusion Financials Training
For more info Visit us:
Soft online said…
Soft online is best Oracle fusion scm training institute in Hyderabad.
Unknown said…
I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

Oracle Fusion SCM Online Training
Goutham Raj said…
Good Blog, well descrided, Thanks for sharing this information.
Oracle Fusion HCM Online Training

Popular posts from this blog

AX - How to use Map and MapEnumerator

Similar to Set class, Map class allows you to associate one value (the key) with another value. Both the key and value can be any valid X++ type, including objects. The types of the key and the value are specified in the declaration of the map. The way in which maps are implemented means that access to the values is very fast.
Below is a sample code that sets and retrieves values from a map.
static void checkItemNameAliasDuplicate(Args _args) { inventTable inventTable; Map map; MapEnumerator mapEnumerator; NameAlias nameAlias; int counter = 0; ; map = new Map(Types::String, Types::Integer); //store into map while select inventTable { nameAlias = inventTable.NameAlias; if (!map.exists(nameAlias)) { map.insert(nameAlias, 1); } else { map.insert(nameAlias, map.lookup(nameAlias) + 1); } } //retrieve from…

Azure DevOps Release Pipeline–Walkthrough

It is a great start to 2019. Joris from Microsoft has welcomed the year with the release of the Azure DevOps Release Pipeline task on the marketplace. Official blog: Addition blog: I thought I would do a walkthrough for those that haven’t had a chance to play with it yet.
New release pipeline In Azure DevOps, click on the New release pipeline.
You will get an option to select from a template. Just select “Empty Job”. In the first stage, make sure the Agent job is using “Hosted VS 2017”.

In the Agent job click on the + icon to add a task. Select the LCS Asset Upload task. If you don’t see, then you have not installed it. Just select the “Dynamics 365 Unified Operations Tools” link at the bottom. Otherwise, install from here…

AX - How to use Set and SetEnumerator

The Set class is used for the storage and retrieval of data from a collection in which the values of the elements contained are unique and serve as the key values according to which the data is automatically ordered.
You can create a set of primitive data types or complex data types such as a Class, Record or Container. Below is sample of a set of records.
static void _Set(Args _args) {     CustTable       custTable;     Set             set = new Set(Types::Record);     SetEnumerator   setEnumerator;     ;     while select custTable     {         if (custTable && !         {             set.add(custTable);         }     }     if (!set.empty())     {         setEnumerator = set.getEnumerator();         setEnumerator.reset();         while (setEnumerator.moveNext())         {             custTable = setEnumerator.current();             info(strfmt("Customer: %1",custTable.AccountNum));         }     } }
Common mistake when creating a set of recIds is…