SAP SQL Anywhere

Question

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

Answer 1

1

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.

permanent link

answered 08 Dec '10, 12:16

Volker Barth
40.2k●361●550●822
accept rate: 34%

1

Works on V10.1.

(23 Dec '10, 07:56) Dmitri

flat view

SAP SQL Anywhere

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

Follow this question

Related questions