To change the owner of a table in MariaDB you can’t directly change it, but you can create a new user, grant him privileges to the table and then drop the old user. However, please be aware that dropping a user will also revoke all the user’s privileges so use this approach cautiously and if it does not take any harm in your scenario. Here are the steps to do it:
1. First, let’s create a new user:
```
CREATE USER ‘newuser’@‘localhost’ IDENTIFIED BY ‘password’;
```
1. Then grant all privileges for the specific table to the new user:
```
GRANT ALL PRIVILEGES ON database_name.table_name TO ‘newuser’@‘localhost’;
```
1. (Optional) If you can delete the old user, do it with this command:
```
DROP USER ‘olduser’@‘localhost’;
```
1. Finally, don’t forget to flush privileges:
```
FLUSH PRIVILEGES;
```
Again, be careful with step 3 because properties that were granted to the ‘olduser’ now will belong to ‘newuser’ but only for `database_name.table_name`. If ‘olduser’ had more permissions in other tables or databases, ‘newuser’ will not adopt those with this method. It is always essential to check the specific needs and settings for your database system.
