Postgres Pro
Downloads
Home   >   mailing lists

Re: Copy user privileges - Mailing list pgsql-sql

From Tom Lane
Subject Re: Copy user privileges
Date
Msg-id 21463.1121195570@sss.pgh.pa.us
Whole thread Raw
In response to Copy user privileges  ("Graham Vickrage" <graham@gpmd.co.uk>)
Responses Re: Copy user privileges
List pgsql-sql
Tree view 
"Graham Vickrage" <graham@gpmd.co.uk> writes:
> I want to keep all the privileges but assign them to a new user. 

> What is the best way of doing this?

How about just renaming the old user to a new name?

I don't think we have an ALTER command for that, but an UPDATE on
pg_shadow would get the job done just as well.
        regards, tom lane

pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: Re: PostgreSQL - ERROR: Cannot cast type character varying to
Next
From: Michael Fuhr
Date:
Subject: Re: Copy user privileges