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


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

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

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

Comments

  • Navin_CNavin_C Vertica Customer
    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
  • Thank you. I could not find in documentation. Yes would be good feature to ask for.
  • 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...


Leave a Comment

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