The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Create new Users along with resource pool and types of access

Hi I wonder how can I create new users with required resource pool configuration along with types of access. Will appreciate if anyone could let me know the command to performed the below mentioned task :


Below is my requirment that i want to create  :-

1. I want to create two new users named Jay and Deepak and I wanted to give complete access to all the layers.( ie like superuser who can access all the layer). Also wanna give ad hoc resource pool.

2. Again I wanted to create another 4 new users named Sandeep, Bharat, Manit and Uttam  and I wanted to give Read only access to profile and reporting layers and ad hoc resource pool


Note : Just incase if you find confusion on layer then you can suggest creating users along with resource pool only based on above 2 points. The 1st points shows creating super user and the 2nd points shows creating normal user having ready only access.


Looking forward to hear from you.







Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file