Create table command fails with permission denied

From: Venkateswara Rao Bondada <Venkateswara_B(at)infosys(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Create table command fails with permission denied
Date: 2009-08-03 12:55:48
Message-ID: 22640DE58AF78445BA8AB69FF76F07321AA2C20C0C@BLRKECMBX01.ad.infosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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));
ERROR: could not create relation "test": Permission denied

Thanks in advance,
Venkat

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ian Lea 2009-08-03 13:08:15 Re: PITR archive_timeout Command
Previous Message Gnanam 2009-08-03 11:35:04 Re: PITR archive_timeout Command