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: amitj...@synechron.com
