On May 10, 2012, at 9:16 PM, Mike Christensen wrote:
> Am I missing something? Doesn't GRANT ALL mean that user can do
> anything they want with objects in that schema, including inserts?
No, it means that user has all privileges on *schema itself*; the objects
inside of it have their own permissions. What you are looking for is:
GRANT ALL ON ALL TABLES IN SCHEMA Indexer TO Indexer;
--
-- Christophe Pettus
[email protected]
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
