| From: | Yinjie Lin <exialin37(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Temporarily disable a role |
| Date: | 2018-06-11 08:24:50 |
| Message-ID: | CA+zFF0d4gCCD4StWmzPLoUW79X+tvB5vc9o-eh666AM3GVbX2w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello everyone.
I'm wondering if there is any way we could disable a role temporarily, and
enable it later.
For example, there are two users u1 and u2. User u1 grants the privileges
of its table t1 to role r1:
> grant all on t1 to r1;
Then, role r1 is granted to user u2:
> grant r1 to u2;
Now user u2 should have access to table t1. Here is my question: can we
disable role r1 so that user u2 will not have permissions on table t1? Note
that role r1 is not removed, so we can enable it later.
I expected ALTER ROLE would have some options dealing with this, but could
not find a proper way. Does anyone have ideas? Thanks in advance.
Best regards
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2018-06-11 08:42:32 | Re: Temporarily disable a role |
| Previous Message | Adrian Klaver | 2018-06-09 23:43:21 | Re: Fwd: compressed bits in sql table |