Unable to create Vertica Objects using Powershell or MS CMD Prompt

Slaagh

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.

marcothesane

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?

Slaagh

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