The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How to find when the user was created?

Hi,

Is there a way to tell when the user account was created in the database? I am trying to list out all the user accounts, their privileges and their created date, but I am not able to get created date information from users or vs_users table.

Thanks,
Rupendra

Comments

  • Hello Rupendra,

     There doesn't seem to be a query that gives exact user account's creation time, there is a way to find the password creation time for a user:

    select passwdcreatetime from vs_users where name ilike '<user_name>';

    However if the user's password was changed at some point of time after the user's creation, then the timestamp returned by the above query will not match the user's creation time. So the timestamp will be equal to the user account creation time only if the password for that user wasn't changed after creation.

    Regards,
    Han

  • Thanks Han.

    In our case, passwords are set to expire in every 90 days. So, it seems we will not be able to find the creation date for most of the users. 

    Regards,
    Rupendra

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file