Re: copying perms to another user - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: copying perms to another user
Date
Msg-id GNELIHDDFBOCMGBFGEFOCEACCFAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: copying perms to another user  (Rod Taylor <rbt@rbt.ca>)
Responses Re: copying perms to another user  (Rod Taylor <rbt@rbt.ca>)
List pgsql-hackers
> 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



pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: copying perms to another user
Next
From: Rod Taylor
Date:
Subject: Re: copying perms to another user