# Can an admin make another user the owner of an email, campaign, or segment?

**URL:** <https://forum.mautic.org/t/can-an-admin-make-another-user-the-owner-of-an-email-campaign-or-segment/24838>\
**Category:** Product Support\
**Created:** [July 22, 2022, 8:28pm UTC](https://forum.mautic.org/t/can-an-admin-make-another-user-the-owner-of-an-email-campaign-or-segment/24838 "2022-07-22T20:28:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![brightworkcreative](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/brightworkcreative/32/1930_2.png) [@brightworkcreative](https://forum.mautic.org/u/brightworkcreative)\
**Post date:** [July 22, 2022, 8:28pm UTC](https://forum.mautic.org/t/can-an-admin-make-another-user-the-owner-of-an-email-campaign-or-segment/24838/1 "2022-07-22T20:28:24Z")

</div>

**Your software**  
My Mautic version is: 4.4  
My PHP version is: PHP 7.4  
My Database type and version is: MariaDB 10.3

Is there any way for an admin to to create an email, campaign, or segment and make another user the owner (the way they can with Contact records)? From a marketing management standpoint, this would be helpful. I’d love to be able to make campaigns, channels, and segments owned by individual sales reps so that they could log into mautic to see only emails and campaigns that pertain to them.

I’ve been using Mautic a long time, and I’m pretty sure it’s not currently possible, but I thought I’d ask in case anyone has found a clever way to do this?

Cheers,  
Scott

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [July 23, 2022, 8:00am UTC](https://forum.mautic.org/t/can-an-admin-make-another-user-the-owner-of-an-email-campaign-or-segment/24838/2 "2022-07-23T08:00:20Z")

</div>

Hey, I can confirm, it’s not possible at the moment. But great suggestion.  
There is a ‘created by’ field in campaigns, emails, forms, which determines the access if you set up roles.  
This proposed admin function needs to change it.  
You can’t even edit this via api, cause the api user will be the creator.  
J

---

<div class="post-metadata">

**Author:** ![pjrobertson](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/pjrobertson/32/2073_2.png) [@pjrobertson](https://forum.mautic.org/u/pjrobertson)\
**Post date:** [August 22, 2023, 9:25am UTC](https://forum.mautic.org/t/can-an-admin-make-another-user-the-owner-of-an-email-campaign-or-segment/24838/3 "2023-08-22T09:25:46Z")

</div>

This is a real PITA. Here’s how to do it editing the MySQL.

1. Find the id of the email you wish to change by opening it in the UI from Channels \> Emails. You’ll see the id in the URL. E.g. [https://examples.com/s/emails/view/584](https://examples.com/s/emails/view/584)  
The id is 584
2. Find the id of the user you wish to change by opening the user in the UI from Settings Cog \> Users. You’ll see the id in the URL. E.g. [https://example.com/s/users/edit/16](https://example.com/s/users/edit/16)  
The id is 16
3. Open up your MySQL, and use the following: `update emails set created_by=16 where id=584;`

To summarize, use:

`update emails set created_by=<USER_ID> where id=<EMAIL_ID>;`

You may also want to update the `created_by_name` as well. Don’t ask me why that’s hard-coded in the database 🤦‍♂️