| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | Andrus <eetasoft(at)online(dot)ee>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Change owner of all database objects |
| Date: | 2006-01-18 14:42:32 |
| Message-ID: | 94325332-6FAB-4701-8F92-7578F23CA2F3@pgedit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Jan 18, 2006, at 4:02 AM, Richard Huxton wrote:
> 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.
You can find some plpgsql functions here:
http://pgedit.com/tip/postgresql/access_control_functions
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | FERREIRA, William (GFI INFORMATIQUE) | 2006-01-18 14:50:31 | Re: Change owner of all database objects |
| Previous Message | Berend Tober | 2006-01-18 14:32:22 | Re: Image in postgresql 7.3 |