web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

How to export All user permession by using X++ in AX2009?

(0) ShareShare
ReportReport
Posted on by 113

Hello guys,

As   the  title  show,do  you  know  how  to do  it   in  AX2009?

I have the same question (0)
  • Suggested answer
    GirishS Profile Picture
    27,843 Moderator on at

    Hi Tracy,

    Refer to the below thread and see if it helps.

    https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/448979/how-to-export-permissions-from-ax?pifragment-109373=2#responses

    Thanks,

    Girish S.

  • Tracy wang Profile Picture
    113 on at

    Hello Girish,

    I have tested according to this document, and this code is wrong, and this post has no correct answer in the end

  • Tracy wang Profile Picture
    113 on at

     This   is  error  detail.

  • GirishS Profile Picture
    27,843 Moderator on at

    Refer to the below blog for exporting data from AX 2009 to excel.

    http://vardhan24.blogspot.com/2014/01/how-to-export-data-from-ax-2009-to.html

    Thanks,

    Girish S.

  • Tracy wang Profile Picture
    113 on at

    I am  so  sorry  about   that  i  can't  open  this  website in china.

  • GirishS Profile Picture
    27,843 Moderator on at

    Just try to use normal export to excel code in AX 2009. Type in the Google search and you will get desired results for exporting to excel via code. Just follow that and see if it works instead of exporting to CSV file as mentioned in the above thread.

    Thanks,

    Girish S.

  • Tracy wang Profile Picture
    113 on at

    I know how to export CSV files, but how to get the corresponding data of users and permissions?

  • Tracy wang Profile Picture
    113 on at

     I have exported EXCEL following the first link, but it is clear that the data is not what I want

  • GirishS Profile Picture
    27,843 Moderator on at

    As per the above thread they are using AccessRightsList Table to get user permission under system documentation.

    Thanks,

    Girish S,

  • Tracy wang Profile Picture
    113 on at

    Yes,But  these  datas   are  not  what  i  want to get

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 617

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 461 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 298 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans