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

Enable multiple users (100+) in one go after DB refresh

(1) ShareShare
ReportReport
Posted on by
Hi,
 
Recently I refreshed one of my sandbox environments. Post this action, all users except myself (I'm the admin) got disabled.
 
Is there a way to enable them in one-go? There are over 100 users in the system and it will take time to enable them one by one.
 
Thanks. 
I have the same question (0)
  • Suggested answer
    Martin Dráb Profile Picture
    238,747 Most Valuable Professional on at
    You can connect to the database and do it by SQL. If you aren't familiar with it, read Enable just-in-time database access.

    I assume you may also be able to use other ways such as data management.
  • André Arnaud de Calavon Profile Picture
    303,310 Super User 2026 Season 1 on at
    Hi,
     
    In addition to the reply from Martin, you can also consider creating a Power Automate flow or use the Excel add-in for enabling the users.

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
André Arnaud de Calavon Profile Picture

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

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 399

#3
Adis Profile Picture

Adis 251 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans