Re: Temporarily disable a role - Mailing list pgsql-admin

From Stéphane KANSCHINE
Subject Re: Temporarily disable a role
Date
Msg-id 20180611091400.u7xxq7v2doerlntj@office.hexack.fr
Whole thread Raw
In response to Temporarily disable a role  (Yinjie Lin <exialin37@gmail.com>)
List pgsql-admin
Le lun. 11 juin, vers 16:24, Yinjie Lin exprimait :

> Hello everyone.

Hey !

> I'm wondering if there is any way we could disable a role temporarily, and
> enable it later.

Maybe you should create a group, add your grants to this group and create
users into this group. Then, when you want to "disable", you just have
to remove this from the group:
https://www.postgresql.org/docs/10/static/sql-creategroup.html

Regards,
-- 
Stéphane KANSCHINE - https://www.hexack.fr./ - https://www.nuajik.io./
@ stephane@hexack.fr
  +33 6 64 31 72 52


pgsql-admin by date:

Previous
From: Yinjie Lin
Date:
Subject: Re: Temporarily disable a role
Next
From: pavan95
Date:
Subject: Re: PostgreSQL 'Corruption & Fragmentation' detection andresolution/fix