We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Vertica user creation date — Vertica Forum

Vertica user creation date

✭
in General Discussion

Hi,

Can we find user creation date in Vertica?

Need for Audit purpose.

Thanks,
Avinash

Tagged:

Answers

  • Administrator

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

  • Administrator

    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)

This discussion has been closed.