| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Saltsgaver, Scott" <scottsa(at)aiinet(dot)com> |
| Cc: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Granting of permissions on tables |
| Date: | 2000-10-05 21:37:49 |
| Message-ID: | 17228.970781869@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
"Saltsgaver, Scott" <scottsa(at)aiinet(dot)com> writes:
> Is this a bug or desired behavior? I would imagine since I owned the tables
> and then granted permissions to another user, I wouldn't lose my
> permissions.
It's a bug, or at least a misfeature. As long as you haven't done any
explicit grants or revokes, 7.0 uses an implicit access control list
that grants all privileges to the owner and none to anyone else.
However, the moment you do any explicit grant/revoke, that implicit
ACL entry for the owner isn't used anymore. You have to explicitly
grant rights to yourself again :-(.
You don't need superuser help to do this, you just have to do
GRANT ALL ON table TO yourself
as the table owner. But it's stupid to have to do that when it's
supposed to be the default condition. Fixed for 7.1.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-10-06 05:01:47 | Re: Counting bool flags in a complex query |
| Previous Message | Peter Eisentraut | 2000-10-05 21:26:46 | Re: Granting of permissions on tables |