Re: [ADMIN] Create table command fails with permission denied

2009-08-04 Thread Venkateswara Rao Bondada
Hi, To add some more details to my question, I'm using postgres account (which is a superuser in the database) to create table. Table creation is working fine in other databases except in this (cms). As postgres user, I granted CREATE, USAGE & ALL privileges to postgres account, still it didn't

Re: [ADMIN] Create table command fails with permission denied

2009-08-03 Thread AmitKumar Jain
Venkateswara Rao Bondada wrote: Hi, I'm new to PostgreSQL, and currently facing an issue with PostgreSQL 7.4 database. I'm getting the following error when tried to create a table. Please let me know the steps (with queries) that I should take care to resolve this issue. cms=# create

[ADMIN] Create table command fails with permission denied

2009-08-03 Thread Venkateswara Rao Bondada
Hi, I'm new to PostgreSQL, and currently facing an issue with PostgreSQL 7.4 database. I'm getting the following error when tried to create a table. Please let me know the steps (with queries) that I should take care to resolve this issue. cms=# create table test(id character varying(80)); ERRO