| From: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
|---|---|
| To: | dd <rigalkin(at)luch(dot)podolsk(dot)ru> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Bugs List <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #1161: User permissions are kept, even if user is |
| Date: | 2004-07-02 09:23:16 |
| Message-ID: | Pine.LNX.4.58.0407021118360.27076@sablons.cri.ensmp.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
> And I have still a question:
> How to remove privileges of the nonexistent (removed) user?
I'm not sure it is even desirable?
There are 2 differents concepts:
- logins with a user name, password...
- sysids which is really an int.
a login must have a sysid, but a sysid may or may not correspond to a
login.
As it is implemented, the privileges belong to the sysids.
This give the opportunity (let's call that a feature) to recreate
a deleted user that would reclaim its previous status wrt priviliges.
> And the offer:
> Can realize removal of privileges of nonexistent users during time vacuum?
Although that could be done, I'm not sure I would like such a thing
to happen.
--
Fabien Coelho - coelho(at)cri(dot)ensmp(dot)fr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | vertigo | 2004-07-02 10:24:24 | 7.4: serial not working ? |
| Previous Message | dd | 2004-07-02 08:40:15 | Re: BUG #1161: User permissions are kept, even if user is |