> On Mon, 2003-01-13 at 21:40, Christopher Kings-Lynne wrote:
> > Often I need to remove a user and cede their permissions to
> someone else.
> > How about something like this:
> >
> > DROP USER blah PERMISSIONS TO chriskl;
>
> If you check that it's a superuser doing the drop, this would be good.
>
> However, what (and how many) databases will this command work on? Only
> the current one? All of them?
Yeah good point...it wouldn't bother me if it were just current database,
except that then it wouldn't be useful to use the DROP USER command. ALTER
USER or GRANT would be better.
BTW Rod, I now get all your emails just fine (not as attachements) - did you
change something?
Chris