Re: ERROR

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