Обсуждение: ERROR

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!!!

Serge:
OS linux, my distro is debian
I don't changes in the configuration
Instalation:
Download tar file
unzip
cd /pghead
 ./configure
  make
  su
  make install
  adduser postgres
  mkdir /usr/local/pgsql/data
  chown postgres /usr/local/pgsql/data
  su postgres
  /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
  /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &

and informix parche:
wget http://informix.postgresintl.com/postgresql020705.tar.gz


Serge Fonville escribió:
> A little more information would be useful
>
> What OS are you running
> What changes have you made to the configuration
> What steps have you taken to install PostgreSQL
>
> Regards,
>
> Serge Fonville
>
> On Mon, Nov 17, 2008 at 4:08 PM, Gustavo Rosso <grosso@sadaic.org.ar
> <mailto:grosso@sadaic.org.ar>> 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)*
>     Help me!!!
>
>     --
>     Sent via pgsql-general mailing list (pgsql-general@postgresql.org
>     <mailto:pgsql-general@postgresql.org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/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

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