Re: Change owner of all database objects

From: Richard Huxton <dev(at)archonet(dot)com>
To: Andrus <eetasoft(at)online(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Change owner of all database objects
Date: 2006-01-18 09:02:24
Message-ID: 43CE0420.1020102@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andrus wrote:
> Currently all my database objects are owned by superuser postgres .
>
> I need to change owner to a nonprivileged role for all objects in a
> database.
>
> I'm using Postgres 8.1 server and client in Windows XP, only plpSQL language
> installed in server.

Search the mailing list archives. I seem to remember solutions involving
shell and perl (and you could install perl if you wanted) but I think
also something in plpgsql.

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-01-18 09:05:25 Re: Partitioning: Planner makes no use of indexes on inherited
Previous Message Richard Huxton 2006-01-18 09:01:23 Re: Modify the password of the service account?