Unable to create Vertica Objects using Powershell or MS CMD Prompt

edited October 2017 in General Discussion


I have an issue with Powershell.

I am not able to CREATE objects using Powershell. I can only SELECT objects. I am having the same issue with MS CMD Prompt. I am not sure if there is a command that I can set, or if the DBA has to handle this.

Any ideas folks? And as always, thank you in advance for your time.


  • Options
    marcothesanemarcothesane - Select Field - Administrator

    What command are you using to CREATE objects? I don't think Powershell is the problem.
    From a windows command line, you would use vsql, Vertica's sql interpreter to create objects in Vertica (what you see on several lines goes on one line):
    C:\1\Vertica> vsql -h -U dbadmin -w dbadmin -d sbx_marco -c "create table bar(id int,name varchar(32))"

    This is the message I get: a warning about an automatic GRANT, and the success message CREATE TABLE:

    WARNING 6978: Table "bar" will include privileges from schema "public" CREATE TABLE

    And, as you can see, I succeed. What are you trying, and what happens?

  • Options

    I just logged in as a different user. Thank you very much for your time :)

Leave a Comment

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