Skip site navigation (1) Skip section navigation (2)

Re: Removing Users and Revoking Privileges

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 (view raw or flat)
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.

In response to

pgsql-general by date

Next:From: Erik JonesDate: 2008-02-29 20:55:28
Subject: Re: SERIAL and Primary Key
Previous:From: Mike GouldDate: 2008-02-29 20:28:11
Subject: SERIAL and Primary Key

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group