Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Unable to create Vertica Objects using Powershell or MS CMD Prompt

edited October 2017 in General Discussion

Hello,

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.

Comments

  • marcothesanemarcothesane 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 172.16.61.128 -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?

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

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.