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 ONE Support launchpad (Login required).

Search for additional results

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