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