Nicola Benaglia <nico.benaz@xxxxxxxxx> 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° ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
