Skip to main content

What is the command to check the list of username for database login ?

  • May 7, 2017
  • 2 replies
  • 14 views
UJJWAL_RANA
Forum|alt.badge.img+2

Hi
I know like /opt/vertica/bin/vsql -U is the command to login to database but my problem here is i don't know the username of the database. Therefore, Please let me know what is the command to find the list of username available for the database login.

I tried /opt/vertica/bin/vsql -l -U but this were wrong.

Will look forward to hear from you

Thank You

Ujjwal Rana

    2 replies

    bhanu_kishore
    Forum|alt.badge.img
    • bhanu_kishore
    • Participating Frequently
    • May 8, 2017

    You can get db admin user(which we used while creating vertica cluster) name under following directory on any of one of the node in the cluster.
    /opt/vertica/config/users

    RaghavA
    Forum|alt.badge.img
    • RaghavA
    • Participating Frequently
    • May 8, 2017

    Hello Ujjwal,

    There is no direct method to list usernames before you logged into the database.

    Only method is to first login into database using normal user, or SuperUser and then list all available users using 2 methods:

    1) On "vsql" prompt, use "\du" command to list all available users. Or,
    2) Use the command which Bhanu shared with us in earlier post:

    select user_name from users;

    Regards,
    Raghav

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement