Обсуждение: 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