Re: Create table command fails with permission denied
2009-08-03 13:33:10 GMT
Venkateswara Rao Bondada wrote:
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));
ERROR: could not create relation "test": Permission denied
Thanks in advance,
login with postgres user like psql -Upostgres cms and THEN execute create table statement.
Refer this : http://www.postgresql.org/docs/7.4/static/sql-grant.html