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
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 pageThis 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.