Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 29 Feb 2008 17:53:39 -0300
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.
- References:
- Removing Users and Revoking Privileges
- From: Carl McCalla
- Removing Users and Revoking Privileges
- Prev by Date: SERIAL and Primary Key
- Next by Date: Re: SERIAL and Primary Key
- Previous by thread: Re: Removing Users and Revoking Privileges
- Next by thread: SERIAL and Primary Key
- Indexes: