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

From Peter Eisentraut
Subject Re: copying perms to another user
Date
Msg-id Pine.LNX.4.44.0301141814220.789-100000@localhost.localdomain
Whole thread Raw
In response to copying perms to another user  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: copying perms to another user
List pgsql-hackers
Christopher Kings-Lynne writes:

> Often I need to remove a user and cede their permissions to someone else.

If this happens to you a lot, the solution is to implement roles, grant
privileges to a role, grant the role to a user, and when you remove the
user you grant the role to someone else.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: [GENERAL] Server error and deadlocks
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: copying perms to another user