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
Last activity: Mar 17, 2025, 05:08 AM