Arrange for the default permissions on a database to allow temp table
Tom Lane <tgl@sss.pgh.pa.us>
Arrange for the default permissions on a database to allow temp table creation to world, but disallow temp table creation in template1. Per latest round of pghackers discussion. I did not force initdb, but the permissions lockdown on template1 will not take effect unless you do one (or manually REVOKE TEMP ON DATABASE template1 FROM public).
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/grant.sgml | modified | +8 −6 |
| src/backend/commands/dbcommands.c | modified | +7 −2 |
| src/backend/utils/adt/acl.c | modified | +3 −3 |
| src/bin/initdb/initdb.sh | modified | +9 −1 |