Excellent, thanks so much! Mike On Thu, May 10, 2012 at 9:38 PM, Christophe Pettus <xof@xxxxxxxxxxxx> wrote: > > 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 > xof@xxxxxxxxxxxx > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]
|
|