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)

Sort by

Verified answer

dekaasboer 1,530 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Anton Venter 20,680 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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