We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Create new Users along with resource pool and types of access — Vertica Forum

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 following task :

 

Below is  my requirement.

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) and wanna add under 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 want to add 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.

 

Thanks

 

Ujjwal

 

Leave a Comment

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