Friday, 14 February 2014

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.

2014-02-10_1455

5 comments:

Anonymous said...

I have found success utilizing Arbela's Security Manager: http://lnkd.in/bWbFJR2

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 !

CHINTAN MUNSHI 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