Gustavo Rosso wrote: > I create a db wiht user postgres, but other users can't no create > tables, and I give all privileges. > > (banco is my db) > > grant all on database banco to public; > grant create on database banco to public; > > This is the error: > *ERROR: must be owner of relation (table)*
The user running the GRANT command must be the table owner or (I think) a database superuser. For table creation, you may need to GRANT the CREATE permission (or ALL permissions) on the `public' schema. I can't remember off the top of my head. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
