Re: Copy user privileges

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Graham Vickrage" <graham(at)gpmd(dot)co(dot)uk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Copy user privileges
Date: 2005-07-12 19:12:50
Message-ID: 21463.1121195570@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Graham Vickrage" <graham(at)gpmd(dot)co(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2005-07-12 19:29:16 Re: Copy user privileges
Previous Message Mauricio Fernandez 2005-07-12 12:49:46 Re: PostgreSQL - ERROR: Cannot cast type character varying to integer