Create new Users along with resource pool and types of access

UJJWAL_RANA

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.

 

Thanks

 

Ujjwal

 

[Deleted User]

I am not 100% sure if I understand the request. but this is the CREATE USER statement

 

CREATE USER name
... [ ACCOUNT {LOCK | UNLOCK} ]
... [ IDENTIFIED BY 'password' ]
... [ MEMORYCAP {'memory-limit' | NONE} ]
... [ PASSWORD EXPIRE ]
... [ PROFILE {profile | DEFAULT} ]
... [ RESOURCE POOL pool-name ] <== You setup the pool here
... [ RUNTIMECAP {'time-limit' | NONE} ]
... [ TEMPSPACECAP {'space-limit' | NONE} ]
... [ SEARCH_PATH {schema[,schema2,...]} | DEFAULT ]

http://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/CREATEUSER.htm%3FTocPath%3DSQL%2520Reference%2520Manual%7CSQL%2520Statements%7C_____53

 

If you want to assign them particular permissions you just need to create the roles and Grant the user the role

 

GRANT role [,...] ... TO { user | role | PUBLIC } [, ...]
... [ WITH ADMIN OPTION ];

 

http://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/GRANT/GRANTRole.htm%3FTocPath%3DSQL%2520Reference%2520Manual%7CSQL%2520Statements%7CGRANT%2520Statements%7C_____5

 

Hope this helps,

 

Eugenia