v.23.9New Feature

Allow Custom Expiration Date for User Credentials

Official CH changelog text
Allow specifying the expiration date and, optionally, the time for user credentials with VALID UNTIL datetime clause. #51261 (Nikolay Degterinsky).
Add support for specifying the expiration date and time of user credentials using the VALID UNTIL datetime clause.

Why it matters

This feature allows administrators to set an expiration datetime for user credentials, enhancing security by automatically disabling access after the specified time. It helps in managing temporary access and enforcing credential renewals without manual intervention.

How to use it

When creating or altering a user, include the VALID UNTIL datetime clause with the desired expiration date and time. For example:

CREATE USER username
IDENTIFIED WITH sha256_password BY 'password'
VALID UNTIL '2024-12-31 23:59:59';

Related resources

PreviousNext