Re: ERROR

From: Lennin Caro <lennin(dot)caro(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org, Gustavo Rosso <grosso(at)sadaic(dot)org(dot)ar>
Subject: Re: ERROR
Date: 2008-11-17 14:51:29
Message-ID: 142281.37223.qm@web59511.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> From: Gustavo Rosso <grosso(at)sadaic(dot)org(dot)ar>
> Subject: [GENERAL] ERROR
> To: pgsql-general(at)postgresql(dot)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

In response to

  • ERROR at 2008-11-17 15:08:02 from Gustavo Rosso

Browse pgsql-general by date

  From Date Subject
Next Message paulo matadr 2008-11-17 14:53:34 Res: Res: Archive files growth!!!
Previous Message Scott Marlowe 2008-11-17 14:50:14 Re: List Ettiquette (perhaps Off Topic by now) was: Re: Database access over the Internet...