Can you set a limit on the number of concurrent user connections by a particular user?

Natasha_2

I need limit concurrent user connections by the user.  Can I do this and how I do this?

Navin_C

Hi Natasha,

You can limit maximum client session on the database level.
But I don't think there is any feature to allow number of client sessions for a particular user.

This will be a good feature to add.

Hope this helps.
NC

Natasha_2

Thank you. I could not find in documentation. Yes would be good feature to ask for.

colin_loghin

Check this link. A workaround ( i have not tried it to see whether it works well) is to set up a resource pool for the restricted user and set a maxconcurrency cap on the pool. Memory can be set via maxmemorysize with a memorysize of 0 to avoid setting memory aside for this occasional user. This feature could also be used to limit a set of users to a number of running queries ( not sessions) 

http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/AdministratorsGuide/ResourceManager/Scenar...