Postgres Pro
Downloads
Home   >   mailing lists

Copy user privileges - Mailing list pgsql-sql

From Graham Vickrage
Subject Copy user privileges
Date
Msg-id 013301c586dc$369ad110$0c67a8c0@gvickrage
Whole thread Raw
Responses Re: Copy user privileges
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: CG
Date:
Subject: Re: Clustering problem
Next
From: "Mauricio Fernandez"
Date:
Subject: Re: PostgreSQL - ERROR: Cannot cast type character varying to integer