Copy user privileges

From: "Graham Vickrage" <graham(at)gpmd(dot)co(dot)uk>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Copy user privileges
Date: 2005-07-12 12:21:21
Message-ID: 013301c586dc$369ad110$0c67a8c0@gvickrage
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi All,

I have dumped a database with no data and restored it with a new db
name.

I want to keep all the privileges but assign them to a new user.

What is the best way of doing this? Is it to alter the system tables
directly in which case which ones.

TIA,

Graham

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mauricio Fernandez 2005-07-12 12:49:46 Re: PostgreSQL - ERROR: Cannot cast type character varying to integer
Previous Message Christoph Haller 2005-07-12 11:34:40 Re: PostgreSQL - ERROR: Cannot cast type character varying to