SAP Knowledge Base Article - Preview

2285135 - sa_get_user_status could show incorrect "last_login_time" for a user - SAP IQ 16


In a MPX environment, a login policy defines "max days since login execeeded" to N days. The user "User1" follows this login policy.

User1's login was locked on a writer node and sa_get_user_status shows that his "last_login_time" was N days ago.

However, User1 has logged in and out since the last N days thus his "last_login_time" should be updated to a more recent date.

If you execute the command "cat IQMSG |grep -i User1" ,  you can see lots of connects/disconnects from this user during the past N days.



IQ 16 SP 8


SAP IQ 16.0


CR796124 ; 796124 ; sa_get_user_status ; last_login_time ; login policy ; login ; locked ; reset ; unlock ; user ; , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.