Unable to create Vertica Objects using Powershell or MS CMD Prompt

Forum|Forum|8 years ago
October 16, 2017
2 replies
13 views

+1

Slaagh
Participating Frequently

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.

+1

marcothesane
Participating Frequently
Forum|Forum|8 years ago
October 17, 2017

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?