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
