How to Export Role,Duty and Privilege in AX 2012

(0) Share

Report

Posted on by Community Member

Hi,

Is there any report or Job in AX 2012 which will give Role name,Duties assigned to the role and Privileges assign to the duties for the Users.

Regards,

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (0)

Suggested answer

Sohaib Cheema 48,805 User Group Leader on at

Like (0)

Report

RE: How to Export Role,Duty and Privilege in AX 2012

In standard AX no report with such details.

Can be developed easily, needs customization.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to Export Role,Duty and Privilege in AX 2012

Hi Sohaib,

I am able to export Roles but how Duties and Privilege can be export. i mean to say which table in Ax contain these Duties and Privilege information.

Regards,

Was this reply helpful? Yes No
Community Member on at

Like (2)

Report

RE: How to Export Role,Duty and Privilege in AX 2012

Security duties are in table SecurityTask with Type equal to 1 (SecurityTaskType::Duty).

Security privileges are in table SecurityTask with Type equal to 0 (SecurityTaskType::Privilege)

Security process cycles are in table SecurityTask with Type equal to 2 (SecurityTaskType::ProcessCycle).

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

RE: How to Export Role,Duty and Privilege in AX 2012

Roles are stored in SecurityRole

User to role mappings in SecurityUserRole

Duty to privileges mappings are stored in SecuritySubTask

Role to duty mappings are stored in SecurityRoleTaskGrant

Was this reply helpful? Yes No
Suggested answer

Sohaib Cheema 48,805 User Group Leader on at

Like (1)

Report
RE: How to Export Role,Duty and Privilege in AX 2012

Here you go

select * from securitytask where Type =1 --Duties select * from securitytask where Type =0 --Privilege

to get it user wise

https://tahseenahmed.wordpress.com/2013/05/06/dax-how-to-get-the-list-of-roles-assigned-to-a-user-%E2%80%8F/

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to Export Role,Duty and Privilege in AX 2012

Hi Sohaib,

I didnot find table securitytask in AX 2012 R3.

Regards,

Was this reply helpful? Yes No
Suggested answer

Sohaib Cheema 48,805 User Group Leader on at

Like (0)

Report

RE: How to Export Role,Duty and Privilege in AX 2012

you will not find it in AOT, because its secured as it is existing in model DB

you have to write query in X++ to get data from it.

or create views in AX based on these tables and then use those views.

if you will try to create an AOT query, you would be able to specify these tables as datasource in properties of query.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to Export Role,Duty and Privilege in AX 2012

You will be able to find that tables in systemdocumentation node in AOT.

Was this reply helpful? Yes No
psined on at

Like (1)

Report

RE: How to Export Role,Duty and Privilege in AX 2012

I know this is an old thread, but I wanted to comment. As others already advised, SecurityTask isn't a real table in CU8. However, I found that there is a SQL view called SecurityTask, which is based on ModelSecurityRole table. On another hand, when I expand records returned by SysSecRoleAddTasks form (filter set to Privileges) to see record info->show all fields, there are RecIds which I can't find by SQL query in SecurityTask view. So I wonder what is SecurityTask view used for?

Was this reply helpful? Yes No
Suggested answer

Roger M. 302 on at

Like (0)

Report

RE: How to Export Role,Duty and Privilege in AX 2012

Is not better use the option export from AOT?

Was this reply helpful? Yes No