Vertica user creation date

avinash1avinash1 ✭
in General Discussion

Hi,

Can we find user creation date in Vertica?

Need for Audit purpose.

Thanks,
Avinash

Tagged:

Answers

  • SruthiASruthiA 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

  • SruthiASruthiA 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.