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?

  1. Implement roles in you DB.
  2. Manage grants on the schemas using roles definition.(single point)
  3. 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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.