Re: User profile

Hi Siraj,

There are no resource profiles in Postgres. You may create and use ROLES
for such requirements. E.g.

CREATE ROLE limited_user WITH LOGIN CONNECTION LIMIT 5;
ALTER ROLE limited_user SET work_mem = '64MB';
ALTER ROLE limited_user SET statement_timeout = '30s';

For more please explore PostgreSQL documentation as suggested above by
David.

Regards,
Muhammad Ikram,
Bitnine Global

On Fri, Jul 12, 2024 at 7:59 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

>
> On Thursday, July 11, 2024, Siraj G <tosiraj(dot)g(at)gmail(dot)com> wrote:
>>
>>
>> I wonder if there is any similar concept we can explore in PgSQL?
>>
>
> https://www.postgresql.org/docs/current/user-manag.html
>
> David J.
>

--
Muhammad Ikram