Hi, > I am wondering if we could have a configure-time or install-time > option to make pg_shadow (and pg_group I guess) be database-local > instead of installation-wide. I am not sure about the implications > of this --- in particular, is the notion of a database owner still > meaningful? How could the postmaster cope with it (I'd guess we'd > need multiple flat files, one per DB, for the postmaster to read)?
I realy like the idea, but how would you handle the postgres (super)user in this scenario? One global postgres user, or a separate one for each db? In the last case, the DB owner would be the DB-specific postgres user. A global superuser would still be needed for backups and other maintainance tasks... Sander ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org