Vertica user creation date

avinash1

Hi,

Can we find user creation date in Vertica?

Need for Audit purpose.

Thanks,
Avinash

SruthiA

yes.. it is present in vs_users table starting 24.3 . if you are on a lower version, please upgrade to avail this feature

SruthiA

Please find sample below. create time is added only for new users created after upgrading to 24.3

eonv242=> select name, create_time from vs_users;
name | create_time
---------+-------------------------------
dbadmin |
test |
adw |

(3 rows)

eonv242=>

eonv242=> create user testnew;
CREATE USER

eonv242=> select name, create_time from vs_users;
name | create_time
---------+-------------------------------
dbadmin |
test |
adw |
testnew | 2024-09-12 10:55:31.958961-04
(4 rows)

eonv242=> select version();

version

Vertica Analytic Database v24.3.0-2
(1 row)