| From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Martin Renters <martin(at)datafax(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: bug in permission handling? |
| Date: | 2002-01-14 20:59:02 |
| Message-ID: | 200201142050.g0EKo8Z18877@neuromancer.ctlno.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Monday 14 January 2002 10:15 am, Tom Lane wrote:
> Martin Renters <martin(at)datafax(dot)com> writes:
> > Isn't it possible for PostgreSQL to delete permissions on tables when a
> > user gets deleted?
>
> Not as long as users span multiple databases. The deleting backend
> can't even get to the other databases in which the user might have
> permissions.
>
Could we have it delete all the users permissions in the current database?
Or at least do this when we have schema support, as I think that there will
typically be only one database (I think that is what I have heard).
I think that extranious permissions whether they are misassgned to a new
user, or not assigned to anyone are a bad thing.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2002-01-14 23:42:52 | Re: bug in permission handling? |
| Previous Message | Jan Wieck | 2002-01-14 20:30:54 | Re: Commercial: New Book!! PostgreSQL book is released into |