sysuser last login time not being updated

[Former Member]

I have a bunch of users that are either:

• not having their last login time logged in the sys.sysuser table OR
• having their last login time being intermittently logged with no discernable pattern.

Obviously, this can't be the intended behavior and would be a large security hole. Is there a flag or property that needs to be set to enable this correctly?

This is in Sybase SQL Anywhere 17 EBF 3339.

[chris_keating]

Can I confirm the platform and build number (I cannot seem to find a 3309 release).

[Former Member]

Mistyped the EBF. Updated it. Just as an aside, I waited until the checkpoint went off, so it's not that.

[Former Member · Accepted solution]

In further discussions with the other developers, we came to the realization that the users were not actually logging into the db. We had a secondary table which was supposed to be duplicating that data, so it appeared as though the users were logging in, but in actuality were not.

[Breck_Carter · Accepted solution]

[VolkerBarth · Accepted solution]

Obviously, you have identified a large security hole and are about to enable the intended behavior yourself, so I turned your posting into an answer...:) - Glad you have found the issue.