Microsoft Dynamics AX (Archived)

Disabling multiple users at once

(0) Share

Report

Posted on by Community Member

Dear all,

Introduction
I am quite new to the world of managing Microsoft Dynamics AX, and hence a basic question.

As I did not find the answer to my question on this forum, I thought it might interest others as well.

Question

Is it possible to disable multiple users at once without using scripts?

Background information

I know users can be disabled by double clicking on a user, clicking Edit and unchecking the Enable box.

This is, however, a lot of work to do for about 400 users. (400 as I want to disable almost all users in the ACP environment, to be enabled only if necessary).
So: is there a faster way to do this? I have a feeling there should be, but have been unable to find it.

Thanks in advance for any tips or advice!

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (2)

Verified answer

dekaasboer 1,530 on at

Like (0)

Report

You could select the option "Edit in Grid" from the form. This way you still need to edit all the users but you'll manage in 10 minutes or less.

Was this reply helpful? Yes No
Iulian Cordobin 8,201 on at

Like (0)

Report

I do not think it's possible without scripting (either a Job or a T-Sql script); that is without having to actually 'click' the number of times of the users you are going to disable.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you, Rik, I knew there should be a quick solution to this

Was this reply helpful? Yes No
Verified answer

Anton Venter 20,346 Super User 2025 Season 2 on at

Like (1)

Report
Hi Rogier, here two jobs to disable and enable all users. If you are going to use it often, you could put this code in classes and add the menu items to the users form.

static void AV_disableAllUsers(Args _args) { UserInfo userInfo; update_recordSet userInfo setting enable = NoYes::No where userInfo.id != 'Admin'; info("Done!"); }

static void AV_enableAllUsers(Args _args) { UserInfo userInfo; update_recordSet userInfo setting enable = NoYes::Yes where userInfo.id != 'Admin'; info("Done!"); }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

That is a great addition, Anton, although I hope this will not be necessary to use this script too often ;)

Was this reply helpful? Yes No
Hetkey 7 on at

Like (0)

Report

Anton, forgive me for being a noob but..how do I run this in D365?

Was this reply helpful? Yes No
Suggested answer

Umesh Pandit 9,315 User Group Leader on at

Like (0)

Report

To dis enable :

update userinfo set [enable] = 0 where ID <> 'Admin'

To enable :

update userinfo set [enable] = 1 where ID <> 'Admin'

Was this reply helpful? Yes No