Vertica grant user create table 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?
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.