Sample Header Ad - 728x90

Vertica grant user create table

1 vote
1 answer
382 views
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?
Asked by Ron Watkins (21 rep)
Apr 13, 2017, 04:16 PM
Last activity: Mar 17, 2025, 05:08 AM