Can VSQL be used by other than dbadmin users?

I have created a few Vertica users with access to database. How can these users use vsql if the first prompt is for password to database? Database password is dbadmin user password, so in essence these users with be logging with dbadmin access and not their own access.
How can users, other than dbadmin, use vsql to work with database?

Best Answer


  • Options
    SruthiASruthiA Vertica Employee Administrator

    Yes. it can be used by other users. You need to use -U while running the vsql command

    -bash-4.1$ vsql -U test
    Welcome to vsql, the Vertica Analytic Database interactive terminal.

    Type: \h or \? for help with vsql commands
    \g or terminate with semicolon to execute query
    \q to quit

    INFO: Connected to localhost at port 5433.



  • Options

    Sruthi, I am able to access the database via DBVis, but using vsql, I get:
    vsql: FATAL 2248: Authentication failed for username

  • Options
    SruthiASruthiA Vertica Employee Administrator

    Please double check the password you are typing in.. if it still fails with vsql but works with DbViz... please open a support case with screenshots and logs.

  • Options

    Thanks Will do. Yes, password is correct.

  • Options

    Thanks Doug, yes, I do have authentication (local_hash) assigned to these users. I tried your method and yes, it worked when I passed the host name. Appreciate the help!

  • Options
    moshegmosheg Vertica Employee Administrator

    When you create a single authentication method, the intent is to lock things down.
    See: https://www.vertica.com/blog/authentication-methods-dbadmin

Leave a Comment

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