Re: Create table command fails with permission denied

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 table test(id character varying(80));
>
> ERROR: could not create relation "test": Permission denied
>
>
>
> Thanks in advance,
>
> Venkat
>

login with postgres user like psql -Upostgres cms and THEN execute
create table statement.

OR
Refer this : http://www.postgresql.org/docs/7.4/static/sql-grant.html
--

Regards,

* *

*Amit Jain **
Synechron Technology Pvt. Ltd.*

Pune 411 057.
Phone : +91.20.40262000 Ext 2162 | Mobile:+91.9373415075 | Fax:
+91.20.30513500
http://www.synechron.com | MailTo: amitjain(at)synechron(dot)com