Finance | Project Operations, Human Resources, ...

How to export permissions from AX

(0) Share

Report

Posted on by mimi51340

Hello,

I need to export permissions (Table and security keys) from AX2009 in an Excel file or csv file.

How can I manage this ?

Thanks a lot.

I have the same question (0)

All responses (25)

Answers (0)

GanapathyS 75 on at

Like (0)

Report

Hello,

You can get permissions/roles of a table by simply right clicking the table>add-ins>security tools>view related security roles.

But it will only gives, roles of the selected table.

If you want to export all the roles at once relate the table SecurityUserRole with SecurityRole in a View and then try exporting.

Was this reply helpful? Yes No
mimi51340 50 on at

Like (0)

Report

Hello,

Thanks for your reply. Yes I need to export all at once. When you say "create a view", what I need to add in this view ?

Thanks you .

Was this reply helpful? Yes No
mimi51340 50 on at

Like (0)

Report

I am checking tables but I cannot see SecurityUserRole table...

Thanks

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi mimi51340,

The reply from Ganapathy is based on AX2012. You are using AX 2009 where the security was implemented in a complete different way. I don't remember the exact table name of the tables used for the permission settings. You can check the form design which table is used. Then you can use the table browser and copy the data to Excel or use the data import/export features to export the contents of the table to a text file.

Was this reply helpful? Yes No
mimi51340 50 on at

Like (0)

Report

Hello,

I think it is the form SysUserSecurity. But it is a tree.

So I do not know how to manage this to get Name, Group, and permissions for every security key and every table;

Thanks

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

I don't have access anymore to an AX 2009 environment, so I can't help that much from my side. Are you able to reverse engineer the form and possible classes called by this form? Then you should be able to find the tables which are used for the security settings.

Was this reply helpful? Yes No
mimi51340 50 on at

Like (0)

Report

Hello,

It is SysUserSecurity Form.

The SysSecurityUser table is called but this table is not visible in the AOT.

So I am not sure it is the right way.

Thanks

Was this reply helpful? Yes No
GanapathyS 75 on at

Like (0)

Report

Hello,

You can find the table in AOT>System Documentation.

Was this reply helpful? Yes No
mimi51340 50 on at

Like (0)

Report

Hello,

I did not find this table in System Documentation.

But I found "AccesRightsList" :

But how can I use this to get the data out?

Thanks

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi mimi51340,

This is indeed the table containing the details you need. Have you tried to create an export group with the Data import/export option using this table name?

Was this reply helpful? Yes No