Privileges
Simon Riggs <simon@2ndquadrant.com>
From: Simon Riggs <simon@2ndQuadrant.com>
To: pgsql-hackers@postgresql.org
Date: 2010-04-19T21:27:39Z
Lists: pgsql-hackers
Attachments
- optional_all.patch (text/x-patch) patch
There is a command to set privileges GRANT SELECT ON ALL TABLES IN SCHEMA foo TO PUBLIC; and a command to set default privileges ALTER DEFAULT PRIVILEGES IN SCHEMA foo GRANT SELECT ON TABLES TO PUBLIC; In the first command the ALL is required, whereas in the second command the ALL must be absent. ISTM that the ALL should be optional in both cases. Same thing is true for FUNCTIONS and SEQUENCES. Both options are new in 9.0. Any objections to implementing this simple patch? -- Simon Riggs www.2ndQuadrant.com