[teiid-issues] [JBoss JIRA] (TEIID-3617) Provide an option to Limit per user based connections

[Kylin Soong (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13255444#comment-13255444 ] 

Kylin Soong commented on TEIID-3617:
------------------------------------

The issue original raised by to much JDBC connections created by a specific user, so if keep limit per user are more straightforward.

There is a sessionMaxLimit default is 1000, each time create a new session a validation addressed, so limit per user should same as sessionMaxLimit, due to there only a single session service, so we don't need consider per vdb and user, security domain in vdb, specify as a system level attribute(rather than transport).

VDB scope setting also supported, like  
{code}
<property name="limit-connections/UserA" value="10"/> 
{code}
If there have vdb scope limit, it will overwrite system level config.

> Provide an option to Limit per user based connections
> -----------------------------------------------------
>
>                 Key: TEIID-3617
>                 URL: https://issues.jboss.org/browse/TEIID-3617
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Server
>            Reporter: Xian Liu
>            Assignee: Kylin Soong
>             Fix For: 9.1
>
>
> we deploy teiid for users to get data, but some users will create many connections to teiid and they are not necessary, I need to find a good way to limit each user account can only get like 50 connections or so



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)