Thread: change owner to all object in a schema

change owner to all object in a schema

From
"Nicola Benaglia"
Date:
Hi!
I searched a lot on the net, but I haven't found a quick way to change
owner to all  objects in a schema.
Could you please suggest me a tool or an existing script to do that ?

Thank you,
Nicola

Re: change owner to all object in a schema

From
Andreas Kretschmer
Date:
Nicola Benaglia <nico.benaz@gmail.com> schrieb:

> Hi!
> I searched a lot on the net, but I haven't found a quick way to change
> owner to all  objects in a schema.
> Could you please suggest me a tool or an existing script to do that ?

There are any scripts, for instance:


13:38 < akretschmer> ??grantall
13:38 < rtfm_please> For information about grantall
13:38 < rtfm_please> see http://pgedit.com/public/sql/acl_admin/index.html
13:38 < rtfm_please> or http://unf.be/postgresql/postgres_grant_all.perl
13:38 < rtfm_please> or http://www.archonet.com/pgdocs/grant-all.html

(answer from the nice doc-bot on our irc-channel)


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

Re: change owner to all object in a schema

From
Greg Smith
Date:
On Fri, 21 Dec 2007, Andreas Kretschmer wrote:

> (answer from the nice doc-bot on our irc-channel)

Which for those of us who hate IRC is also available at
http://search.postgresql.org ; the docbot hits show up at the top before
the main search results.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD