• Nikita Malyavin's avatar
    MDEV-23729 MDEV-32218 INFORMATION_SCHEMA table for user data · d229b4af
    Nikita Malyavin authored
    * A new table INFORMATION_SCHEMA.USERS is introduced.
    * It stores auxiliary user data
    * An unprivileged user can access their own data, and that is the main
      difference with what mysql.global_priv provides
    * The fields are currently: USER, PASSWORD_ERRORS, PASSWORD_EXPIRATION_TIME
    * If password_errors is ignored for the user, PASSWORD_ERRORS is NULL
    * PASSWORD_EXPIRATION_TIME is a timestamp with exact point in time, calculated
    from password_last_changed and password_lifetime (i.e. days) stored for the user
    d229b4af
information_schema_stats.result 8.25 KB