Re: Security settings

> -----Original Message-----
> From: Armbrust, Daniel C. [mailto:Armbrust(dot)Daniel(at)mayo(dot)edu]
> Sent: 18 July 2003 15:47
> To: pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] Security settings
>
>
> I got the error figured out this morning... The clients were
> having issues, because the user that was removed was the
> owner of the tables. So, the tables effectively had no
> owner, causing pgadmin do have different issues in different versions.
>
> I was able to get it fixed (only with the new pgadmin however
> - the old one barfed to bad)
>
> It does bring up what I would call a bug, however... Probably
> in the database, however, and not the gui.
>
> I would think that you should not be able to remove a user
> from a database if that user owns tables. Furthermore, if you
> remove a user, that user should have all of its security
> entries removed from all tables.

Yes. Perhaps the obects should revert to the user that deletes the user.
Problem is that it will likely involve objects in other databases and
cross database queries are not really possible due to the way the
backends work as I understand it.
>
> Dan
>
> ps - sorry for the private mail Dave, all of the other
> mailing lists I am on change the Reply to to point back to
> the list, rather than the sender.

No problem. I must fix that sometime...

Regards, Dave.