Showing user with its roles

(0) Share

Report

Posted on by Shabir Ahmad

3,110

Hi Experts,

I have a requirement users with its roles should be export to excel sheet is it possible?? For example user ABC has 3 roles accountant, Sales manager and system user so this user should be exported to excel sheet with these 3 roles.

Best Regards,

Shabir Ahmad

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

nmaenpaa 101,166 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi Sabir,

you will find this info in SecurityUserRole table. Additionally, company specific role assignments are in OMUserRoleOrganization table.

You should be able to develop a form (to export from Grid to Excel) or a report based on the data in these tables.

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,803 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi,

Isn't the "Security user role assosiation" data entity wont help you in this from data management?

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (1)

Report
Copy link

Link copied!

Thanks to all,

The below link fulfilled my requirement.

axaptacorner.blogspot.com/.../ax-2012.html

Best Regards,

Shabir Ahmad

Was this reply helpful? Yes No