Re: ERROR - Mailing list pgsql-general

From Lennin Caro
Subject Re: ERROR
Date
Msg-id 142281.37223.qm@web59511.mail.ac4.yahoo.com
Whole thread Raw
In response to ERROR  (Gustavo Rosso <grosso@sadaic.org.ar>)
List pgsql-general
> From: Gustavo Rosso <grosso@sadaic.org.ar>
> Subject: [GENERAL] ERROR
> To: pgsql-general@postgresql.org
> Date: Monday, November 17, 2008, 3:08 PM
> 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)*
> Help me!!!
>

alter table  table_name owner to public

the public rol must exist





pgsql-general by date:

Previous
From: Gustavo Rosso
Date:
Subject: Re: ERROR
Next
From: Howard Cole
Date:
Subject: Re: How to reduce impact of a query.