Thread: User profile

There are user profiles we can create in Oracle, say separate ones' for application service users, users used by monitoring tools and IT support users. I wonder if there is any similar concept we can explore in PgSQL?

Regards

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