Postgres Pro
Downloads
Home   >   mailing lists

Re: User profile - Mailing list pgsql-admin

From Muhammad Ikram
Subject Re: User profile
Date
Msg-id CAGeimVodhuojL2n3BCvnC7dTmPGk6k9FxQYx7OqYwn7O61AuGQ@mail.gmail.com
Whole thread Raw
In response to Re: User profile  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view
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.g.johnston@gmail.com> wrote:

On Thursday, July 11, 2024, Siraj G <tosiraj.g@gmail.com> wrote:

 I wonder if there is any similar concept we can explore in PgSQL?


David J.


--
Muhammad Ikram

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: User profile
Next
From: Kashif Zeeshan
Date:
Subject: Re: Oracle to Postgres