[Community feedback] Better user and privilege management

[DavLagoHern]

What problem are you trying to solve?

A recent MariaDB user mentioned that managing users and privileges from database clients can still feel unintuitive.

A GUI could make common tasks easier than remembering the exact GRANT, REVOKE and user-management syntax, while still keeping the resulting database operations clear and reviewable.

The main goal would be to make it easier to understand who has access to what, and to manage those permissions without hiding what is actually happening in the database.

How would you like it to work?

A dedicated user/privilege management view could make it easier to:

• view database users in one place;
• inspect the privileges assigned to each user;
• create or edit users;
• grant and revoke privileges;
• understand global, database and table-level permissions;
• review the SQL that will be executed before applying changes.

The idea would not be to hide GRANT / REVOKE behind a black box, but to provide a clearer UI while still showing what LakeDB is going to execute.

This is community feedback for exploring the workflow, not a planned or shipped feature.

LakeDB area

Security

How often would this help?

Occasionally

Current alternatives

No response

Before posting

• I searched for a similar idea.
• I removed credentials and sensitive data.

[DavLagoHern]

Implemented in LakeDB Beta 5.4.

The new Users and privileges view for MySQL and MariaDB can:

• list the accounts visible to the current connection;
• inspect server-reported privileges at global, database, and table scope;
• create users and change their passwords;
• lock, unlock, rename, or delete accounts;
• grant and revoke the privileges supported by the active server.

LakeDB does not hide these operations behind the interface: every change is converted into SQL for review before it is applied, and the existing Production safeguards remain active. What can be viewed or changed still depends on the permissions of the connected database account.

Release, artwork, and downloads: https://github.com/DavLagoHern/LakeDB/releases/tag/v1.0.0-beta.5.4