How to see date a user was created in Sybase using a select statement?

[Former Member]

Does anyone know how to see the date a user was created in Sybase using a select statement?

[VolkerBarth]

If you are running SQL Anywhere 10 or newer, the following access on the system catalog should work:

select user_name, creation_time
from sys.sysobject key join sys.sysuser
order by 1

I'm not really sure for v10, as I currently use 11.0.1 and 12.0.0, but AFAIK starting with v10 all database objects are contained with their creation timestamp in table sysobject.

---

Note: Starting with v11, sysuser additionally contains a field password_creation_time in case that timestamp is important, too.

[former_SQLA_member1694880]

Works on V10.1.