Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27205

MariaDB user last login time details at DB level

Details

    • New Feature
    • Status: Stalled (View Workflow)
    • Critical
    • Resolution: Unresolved
    • None
    • Server
    • 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.

      Attachments

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-23729 INFORMATION_SCHEMA Table info. about user locked due to max_password_errors

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-32649 Add INFORMATION_SCHEMA Table with user related details

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            danblack Daniel Black added a comment -

            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.

            danblack Daniel Black added a comment - 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.
            suresh.ramagiri@mariadb.com suresh ramagiri added a comment -

            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.

            suresh.ramagiri@mariadb.com suresh ramagiri added a comment - 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.
            ccalender Chris Calender (Inactive) added a comment -

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

            ccalender Chris Calender (Inactive) added a comment - Added feedback, which is a "yes" to Ralf's question.

            People

              ralf.gebhardt Ralf Gebhardt
              suresh.ramagiri@mariadb.com suresh ramagiri
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.