[MDEV-27205] MariaDB user last login time details at DB level Created: 2021-12-08  Updated: 2024-02-05

Status: Open
Project: MariaDB Server
Component/s: Server
Fix Version/s: None

Type: New Feature Priority: Major
Reporter: suresh ramagiri Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

One of our customers requesting for a new feature in having a user last login time or all the users last login time within a database table level.

Like say in the information_schema database some table say "login_tracking" with information of database user last login details.

 Comments   
Comment by Daniel Black [ 2021-12-09 ]

Is it possible to use the audit plugin, and a connect/csv engine table to its logs?

Alternately extending user statistics plugin to include this would be easy, but the details are in memory only.

Comment by suresh ramagiri [ 2021-12-10 ]

As I noted the customer are in need of having the user last login details at database level.
Audit logs/general logs will have the details, but are stored in files, requesting functionality from product without introducing user defined procedures or triggers or any logs, wants to have details at a database table level.

User statistics may help, yes it may need some additional code changes, not sure developers to decide on this.

Comment by Chris Calender (Inactive) [ 2022-02-24 ]

Added feedback, which is a "yes" to Ralf's question.

Generated at Thu Feb 08 09:51:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.