Why is a SQL connection working for a deactivated user with expired password
On our HANA instance we have saved the logon data at a sql connection for an active user. In the meantime this user has been deactivated automatically, because the password of this user has been expired. Therefore this user can no longer logon in HANA studio, in the web editor and no other sql connection can be created with this user as logon user.
This makes surely sense. But is it really wished that the already saved sql connection is still working though the user has been deactivated? Additionally: The password is expired but the system does not force changing the password.
Thanks for every comment giving more background