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?


  • 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.
  • 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)

Leave a Comment

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