From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Carl McCalla <Carl(dot)Mccalla(at)noaa(dot)gov> |
Cc: | pgsql-general(at)postgresql(dot)org, Steve R Olson <Steve(dot)R(dot)Olson(at)noaa(dot)gov> |
Subject: | Re: Removing Users and Revoking Privileges |
Date: | 2008-02-29 20:53:39 |
Message-ID: | 20080229205339.GR4673@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Carl McCalla wrote:
> To All,
>
> I am running Postgres version 7.4.19.
>
> One thing I wanted to do and have successfully completed is changing the
> ownership of a Postgres database and all of its tables to a new owner.
> I have also successfully granted access privileges to the new owner.
FWIW this is all covered in a future Postgres version: if any user has
remaining references on any database, the system won't let you drop it,
and it will produce a list of the affected objects. That way it is a
lot easier to clean the whole thing up.
I know it doesn't solve your problem; I'm just mentioning it in case
you're looking for reasons to migrate to a newer version.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Jones | 2008-02-29 20:55:28 | Re: SERIAL and Primary Key |
Previous Message | Mike Gould | 2008-02-29 20:28:11 | SERIAL and Primary Key |