Обсуждение: limits on the number of concurrent DBMS sessions per account

Поиск
Список
Период
Сортировка

limits on the number of concurrent DBMS sessions per account

От
Kevin Tu
Дата:
Hello team,

Let's say I have a user userA, does anyone know how to limit the number of concurrent sessions for this user? I know in Oracle a simple logon trigger would do it. 

Appreciate any thoughts and/or code snippets in this.

--
Best Regards,
 
Kevin Tu

Re: limits on the number of concurrent DBMS sessions per account

От
Tom Lane
Дата:
Kevin Tu <kevintu888@gmail.com> writes:
> Let's say I have a user userA, does anyone know how to limit the number of
> concurrent sessions for this user?

ALTER USER joe CONNECTION LIMIT 42;

            regards, tom lane



Re: limits on the number of concurrent DBMS sessions per account

От
Kevin Tu
Дата:
Thanks Tom!  As always, you're the best!

On Fri, Mar 4, 2022 at 10:11 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Kevin Tu <kevintu888@gmail.com> writes:
> Let's say I have a user userA, does anyone know how to limit the number of
> concurrent sessions for this user?

ALTER USER joe CONNECTION LIMIT 42;

                        regards, tom lane


--
Best Regards,
 
Kevin Tu