Skip to main content
Question

Vertica user creation date

  • September 12, 2024
  • 2 replies
  • 6 views

avinash1
Forum|alt.badge.img+1

Hi,

Can we find user creation date in Vertica?

Need for Audit purpose.

Thanks,
Avinash

2 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • September 12, 2024

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
Forum|alt.badge.img+1
  • Participating Frequently
  • September 12, 2024

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)