User Management - admin account to only add users with view rights

Hello, I am looking for a solution to create a user account for MariaDB that is only able to create and manage users that are allowed to get data from the database without altering it. The biggest problem that I am seeing is that in order to do proper user management, the user must be able to alter the user table and could create a user that is able to do anything. Maybe there is a solution for that and I haven't come up with it.

Answer Answered by Ian Gilfillan in this comment.

The GRANT OPTION privilege permits the granting of privileges that the user has, so to do what you want to do would probably require a custom solution.


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.