http://simonwillison.net/2010-03-16T18:26:30+00:00Simon Willison2010-03-16T18:26:30+00:002010-03-16T18:26:30+00:00https://simonwillison.net/2010/Mar/16/grant/#atom-tag

<p><strong><a href="http://www.depesz.com/index.php/2007/10/19/grantall/">grant XXX on * ?</a></strong></p> PostgreSQL doesn’t have a way to say “this user is allowed to select/update/etc on all tables in database X”. That kind of sucks. UPDATE: This is fixed in PostgreSQL 9, see the comments. <p><small></small>Via <a href="http://serverfault.com/questions/60508/grant-select-to-all-tables-in-postgresql">GRANT SELECT to all tables in postgresql - Server Fault</a></small></p> <p>Tags: <a href="https://simonwillison.net/tags/databases">databases</a>, <a href="https://simonwillison.net/tags/grant">grant</a>, <a href="https://simonwillison.net/tags/permissions">permissions</a>, <a href="https://simonwillison.net/tags/postgresql">postgresql</a>, <a href="https://simonwillison.net/tags/sql">sql</a></p>