Vertica grant user create table

Question

I have users (developers) in Vertica who need to create tables for testing purposes, which will later be deployed under specific production schema. I do not want them to have the ability to create tables in the production schema though.

Im looking for the grants necessary to allow a user the ability to create tables. Do most environments create a schema for each user and then grant authorization for the user on that schema or what is the best practice?

What should I do when someone answers my question? – Marcello Miorelli Nov 03 '22 at 14:12 — Marcello Miorelli, Nov 03 '22 at 14:12

score 0 · Answer 1 · answered Apr 28 '17 at 00:46

Implement roles in you DB.
Manage grants on the schemas using roles definition.(single point)
Grant these roles to your users.

in regards users development, create a schema for each one of them with full rights (ownership) where they can play as much as they want.

Vertica grant user create table

1 Answers1