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�:
Show quoted text
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 PostgreSQLRegards,
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
Import Notes
Reply to msg id not found: 680cbe0e0811170646h2908c79bu9bd1733c9962fc4f@mail.gmail.com
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