# List of users with locked trust level due to group membership?

**URL:** <https://meta.discourse.org/t/list-of-users-with-locked-trust-level-due-to-group-membership/62455>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [2017年五月10日 18:36 UTC](https://meta.discourse.org/t/list-of-users-with-locked-trust-level-due-to-group-membership/62455 "2017-05-10T18:36:18Z")\
**Posts on this page:** 1\
**Showing post:** 13

<div class="post-metadata">

**Author:** ![cpradio](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cpradio/32/4970_2.png) [@cpradio](https://meta.discourse.org/u/cpradio)\
**Post date:** [2017年五月11日 02:08 UTC](https://meta.discourse.org/t/list-of-users-with-locked-trust-level-due-to-group-membership/62455/13 "2017-05-11T02:08:17Z")

</div>

I believe this should do it. (be sure to backup your instance before running it)

```plaintext
User.where(trust_level_locked: true).update_all(trust_level_locked: false)

```

Edit:  
Well, duh! You could simplify this to (as no user should have a locked TL)

```plaintext
User.update_all(trust_level_locked: false)

```

---

_[View the full topic](https://meta.discourse.org/t/list-of-users-with-locked-trust-level-due-to-group-membership/62455)._