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.
Whatyou are looking for is:
GRANT ALL ON ALL TABLES IN SCHEMA Indexer TO Indexer;
--
-- Christophe Pettus
xof@thebuild.com