Change MariaDB "ADMIN_OPTION" of a ROLE after deleting the user who created it
0
votes
1
answer
79
views
I have a problem in the prod :
I have a user named dba who has all privileges with grant option, i used it to create a role named test, i granted some rights to the role test and granted the role test to the user 'name.name'@'10.25%'.
the problem is that i deleted the user dba, so now my role lost the user who had his ADMIN OPTION.
MariaDB [(none)]> SELECT count(*),User,Role,Admin_option FROM mysql.roles_mapping group by role DESC;
+----------+----------------------+-------------+--------------+
| count(*) | User | Role | Admin_option |
+----------+----------------------+-------------+--------------+
| 1 | name.name | test | N |
+----------+----------------------+-------------+--------------+
now i recreated the user dba,
Is there a way to give back the ADMIN OPTION to dba using another super user like root ?
what are the possible solutions to back to the normal status ?
mariadb info :
Server: MariaDB
Server version: 10.6.8-MariaDB-1:10.6.8+maria~stretch-log mariadb.org binary distribution
Protocol version: 10
Asked by Firas Megrahi
(3 rep)
Mar 29, 2024, 10:39 AM
Last activity: Mar 29, 2024, 04:57 PM
Last activity: Mar 29, 2024, 04:57 PM