grant XXX on * ? (via) 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.
Sign in with 
OpenID
grant XXX on * ? (via) 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.
pg 9 (in alpha now) adds a nicer way of doing it: "grant ... on all tables in public;"
"GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }
[,...] | ALL [ PRIVILEGES ] }
ON { [ TABLE ] table_name [, ...]
| ALL TABLES IN SCHEMA schema_name [, ...] }
TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]"
http://developer.postgresql.org/pgdocs/postgres/sq l-grant.html
Oops, that should have been "grant ... on all tables in SCHEMA public"
BBL3b8 http://fhT2m8CsJk4b0Spe71mfuXz.com
joseph - 1st July 2011 11:10 - #
zNj4D3 http://skU2bgI3cmOpavY2m0kw7t.com
joseph - 3rd July 2011 05:16 - #
TNiVLJKb
IUjFaCY - 27th October 2011 18:59 - #
rgjvKumE
jgXkqoF - 27th October 2011 18:59 - #