Re: Change owner of all database objects - Mailing list pgsql-general

> You can find some plpgsql functions here:
>
> http://pgedit.com/tip/postgresql/access_control_functions


 John, thank you.

I found that acl_admin.grant_on_all() does not grant privileges on schema:
it does not execute

GRANT ALL ON SCHEMA myschema TO myrole;

statements.

So I must execute GRANT ALL ON SCHEMA  commands for each schema manually,
right ?

Andrus.