Welcome to the Vertica community on Rocket Forum
Hi,
Can we find user creation date in Vertica?
Need for Audit purpose.
Thanks, Avinash
yes.. it is present in vs_users table starting 24.3 . if you are on a lower version, please upgrade to avail this feature
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();
Vertica Analytic Database v24.3.0-2 (1 row)
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.