HANA database: Find out users with "disabled password lifetime"

[stefan_sessner]

Hello,

„ALTER USER <USERNAME> DISABLE (or ENABLE) PASSWORD LIFETIME“ enables or disables password lifetime policy for specific HANA DB users.

Question:

Is it possible to select (query via SQL statement) or to list these specific users, which have a disabled or enabled password lifetime?

Thank you in advance.

Kind regards,

Stefan Seßner

[candy_zhan]

Hi Stefan,

Maybe you can refer to the system view USERS. When disable the lifetime, the column PASSWORD_CHANGE_TIME will be null. When the lifetime is enabled, PASSWORD_CHANGE_TIME will show the time you enable it.

Best regards,

Candy Zhan