Skip to main content

Notifications

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. 
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,965 Super User 2025 Season 1 on at
    Enable multiple users (100+) in one go after DB refresh
    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.
  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 230,817 Most Valuable Professional on at
    Enable multiple users (100+) in one go after DB refresh
    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.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans