From Venkateswara_B@infosys.com Mon Aug  3 12:23:12 2009
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 88C0B633923
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon,  3 Aug 2009 09:23:12 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 09917-09 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon,  3 Aug 2009 12:23:01 +0000 (UTC)
X-Greylist: delayed 00:14:33.406167 by SQLgrey-1.7.6
Received: from KECGATE08.infosys.com (Kecgate08.infosysconsulting.com
	[122.98.10.33])
	by mail.postgresql.org (Postfix) with ESMTP id 235A863348C
	for <pgsql-sql@postgresql.org>; Mon,  3 Aug 2009 09:23:00 -0300 (ADT)
X-TM-IMSS-Message-ID: <f8ee0b8d001a31d1@KECGATE08.infosys.com>
Received: from blrkechub01.ad.infosys.com ([10.66.236.41]) by
	KECGATE08.infosys.com ([122.98.10.33]) with ESMTP (TREND IMSS
	SMTP Service 7.0) id f8ee0b8d001a31d1 ;
	Mon, 3 Aug 2009 17:40:31 +0530
Received: from BLRKECMBX01.ad.infosys.com ([10.66.236.21]) by
	blrkechub01.ad.infosys.com ([10.66.236.41]) with mapi; Mon, 3 Aug 2009
	17:38:23 +0530
From: Venkateswara Rao Bondada <Venkateswara_B@infosys.com>
To: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Date: Mon, 3 Aug 2009 17:38:21 +0530
Subject: Create table command fails with permission denied
Thread-Topic: Create table command fails with permission denied
Thread-Index: AcoUMxghWlCW6TQyQ6iY3Ri+Bv3Tcg==
Message-ID: 
 <22640DE58AF78445BA8AB69FF76F07321AA2C20BAB@BLRKECMBX01.ad.infosys.com>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
acceptlanguage: en-US
Content-Type: multipart/alternative;
	boundary="_000_22640DE58AF78445BA8AB69FF76F07321AA2C20BABBLRKECMBX01ad_"
MIME-Version: 1.0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.184 tagged_above=-10 required=5
	tests=BAYES_40=-0.185, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200908/9
X-Sequence-Number: 32918

--_000_22640DE58AF78445BA8AB69FF76F07321AA2C20BABBLRKECMBX01ad_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,
I'm new to PostgreSQL, and currently facing an issue with PostgreSQL 7.4 da=
tabase. I'm getting the following error when tried to create a table. Pleas=
e let me know the steps (with queries) that I should take care to resolve t=
his issue.

cms=3D# create table test(id character varying(80));
ERROR:  could not create relation "test": Permission denied

Thanks in advance,
Venkat

--_000_22640DE58AF78445BA8AB69FF76F07321AA2C20BABBLRKECMBX01ad_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
	{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal>Hi,<o:p></o:p></p>

<p class=3DMsoNormal>I&#8217;m new to PostgreSQL, and currently facing an i=
ssue
with PostgreSQL 7.4 database. I&#8217;m getting the following error when tr=
ied
to create a table. Please let me know the steps (with queries) that I shoul=
d
take care to resolve this issue.<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>cms=3D# create table test(id character varying(80));<o=
:p></o:p></p>

<p class=3DMsoNormal>ERROR:&nbsp; could not create relation &quot;test&quot=
;:
Permission denied<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>Thanks in advance,<o:p></o:p></p>

<p class=3DMsoNormal>Venkat<o:p></o:p></p>

</div>

</body>

</html>

--_000_22640DE58AF78445BA8AB69FF76F07321AA2C20BABBLRKECMBX01ad_--



From robjsargent@gmail.com Mon Aug  3 22:03:12 2009
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 9D0D9634CA6
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon,  3 Aug 2009 19:03:12 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 87915-05 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon,  3 Aug 2009 22:03:02 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from out01.mta.xmission.com (out01.mta.xmission.com [166.70.13.231])
	by mail.postgresql.org (Postfix) with ESMTP id 1F401633F68
	for <pgsql-sql@postgresql.org>; Mon,  3 Aug 2009 19:03:02 -0300 (ADT)
Received: from in02.mta.xmission.com ([166.70.13.52])
	by out01.mta.xmission.com with esmtp (Exim 4.62)
	(envelope-from <robjsargent@gmail.com>)
	id 1MY5ci-0008Ly-II; Mon, 03 Aug 2009 16:03:16 -0600
Received: from [208.187.158.94] (helo=[172.16.1.221])
	by in02.mta.xmission.com with esmtpsa (TLSv1:AES256-SHA:256)
	(Exim 4.69) (envelope-from <robjsargent@gmail.com>)
	id 1MY5cR-00082V-8a; Mon, 03 Aug 2009 16:02:59 -0600
Message-ID: <4A775E91.4090608@gmail.com>
Date: Mon, 03 Aug 2009 16:02:57 -0600
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Thunderbird 2.0.0.22 (X11/20090608)
MIME-Version: 1.0
To: Venkateswara Rao Bondada <Venkateswara_B@infosys.com>
CC: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
References: 
 <22640DE58AF78445BA8AB69FF76F07321AA2C20BAB@BLRKECMBX01.ad.infosys.com>
In-Reply-To: 
 <22640DE58AF78445BA8AB69FF76F07321AA2C20BAB@BLRKECMBX01.ad.infosys.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
X-XM-SPF: eid=; ; ; mid=; ; ; hst=in02.mta.xmission.com; ; ;
 ip=208.187.158.94;
	; ; frm=robjsargent@gmail.com; ; ; spf=neutral
X-SA-Exim-Connect-IP: 208.187.158.94
X-SA-Exim-Rcpt-To: Venkateswara_B@infosys.com, pgsql-sql@postgresql.org,
	robjsargent@gmail.com
X-SA-Exim-Mail-From: robjsargent@gmail.com
X-Spam-DCC: XMission; sa03 1397; Body=1 Fuz1=1 Fuz2=1 
X-Spam-Combo: ;Venkateswara Rao Bondada <Venkateswara_B@infosys.com>
X-Spam-Relay-Country: 
Subject: Re: Create table command fails with permission denied
X-SA-Exim-Version: 4.2.1 (built Thu, 25 Oct 2007 00:26:12 +0000)
X-SA-Exim-Scanned: Yes (on in02.mta.xmission.com)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.185 tagged_above=-10 required=5
	tests=BAYES_40=-0.185
X-Spam-Level: 
X-Archive-Number: 200908/10
X-Sequence-Number: 32919

Looks to me as though you are not the owner of the schema nor superuser 
nor in a role with permission to create tables in said schema. See the 
DBA if it's not you. If it is sign on as postgres (superuser) and grant 
yourself some access rights.



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
>



From Venkateswara_B@infosys.com Tue Aug  4 08:11:46 2009
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 2D23E633EA0
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue,  4 Aug 2009 05:11:46 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 63170-09 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue,  4 Aug 2009 08:11:35 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from KECGATE03.infosys.com (Kecgate03.infosys.com [122.98.10.31])
	by mail.postgresql.org (Postfix) with ESMTP id DBB7B633AB9
	for <pgsql-sql@postgresql.org>; Tue,  4 Aug 2009 05:11:34 -0300 (ADT)
X-TM-IMSS-Message-ID: <fd47fe25001ac644@KECGATE03.infosys.com>
Received: from blrkechub02.ad.infosys.com ([10.66.236.42]) by
	KECGATE03.infosys.com ([122.98.10.31]) with ESMTP (TREND IMSS
	SMTP Service 7.0) id fd47fe25001ac644 ;
	Tue, 4 Aug 2009 13:39:24 +0530
Received: from BLRKECMBX01.ad.infosys.com ([10.66.236.21]) by
	blrkechub02.ad.infosys.com ([10.66.236.42]) with mapi; Tue, 4 Aug 2009
	13:41:31 +0530
From: Venkateswara Rao Bondada <Venkateswara_B@infosys.com>
To: Rob Sargent <robjsargent@gmail.com>
CC: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Date: Tue, 4 Aug 2009 13:41:29 +0530
Subject: Re: Create table command fails with permission denied
Thread-Topic: [SQL] Create table command fails with permission denied
Thread-Index: AcoUhiy6L2J0k/fHROyV05iNeVXegQASHenA
Message-ID: 
 <22640DE58AF78445BA8AB69FF76F07321AA2C2100A@BLRKECMBX01.ad.infosys.com>
References: 
 <22640DE58AF78445BA8AB69FF76F07321AA2C20BAB@BLRKECMBX01.ad.infosys.com>
	<4A775E91.4090608@gmail.com>
In-Reply-To: <4A775E91.4090608@gmail.com>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 200908/14
X-Sequence-Number: 32923

Hi Rob,
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. A=
s postgres user, I granted CREATE, USAGE & ALL privileges to postgres accou=
nt, still it didn't work.
Please find the snapshots below where it works fine and also where it doesn=
't work fine. And let me know what rights postgres account is missing to cr=
eate tables in "cms" database.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
camd=3D# \c camd postgres
You are now connected to database "camd" as user "postgres".
camd=3D# create table test(id character varying(80));
CREATE TABLE
camd=3D# \c cms postgres
You are now connected to database "cms" as user "postgres".
cms=3D# create table test(id character varying(80));
ERROR:  could not create relation "test": Permission denied
cms=3D#
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Thanks,
Venkat


-----Original Message-----
From: Rob Sargent [mailto:robjsargent@gmail.com]=20
Sent: Tuesday, August 04, 2009 3:33 AM
To: Venkateswara Rao Bondada
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Create table command fails with permission denied

Looks to me as though you are not the owner of the schema nor superuser=20
nor in a role with permission to create tables in said schema. See the=20
DBA if it's not you. If it is sign on as postgres (superuser) and grant=20
yourself some access rights.



Venkateswara Rao Bondada wrote:
>
> Hi,
>
> I'm new to PostgreSQL, and currently facing an issue with PostgreSQL=20
> 7.4 database. I'm getting the following error when tried to create a=20
> table. Please let me know the steps (with queries) that I should take=20
> care to resolve this issue.
>
> cms=3D# create table test(id character varying(80));
>
> ERROR: could not create relation "test": Permission denied
>
> Thanks in advance,
>
> Venkat
>



From robjsargent@gmail.com Tue Aug  4 16:33:03 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id B196A635209
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue,  4 Aug 2009 13:33:03 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 93784-04-7 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue,  4 Aug 2009 16:32:51 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from out01.mta.xmission.com (out01.mta.xmission.com [166.70.13.231])
	by mail.postgresql.org (Postfix) with ESMTP id 42F396358E5
	for <pgsql-sql@postgresql.org>; Tue,  4 Aug 2009 13:32:21 -0300 (ADT)
Received: from in01.mta.xmission.com ([166.70.13.51])
	by out01.mta.xmission.com with esmtp (Exim 4.62)
	(envelope-from <robjsargent@gmail.com>)
	id 1MYMwF-0005rs-W4; Tue, 04 Aug 2009 10:32:36 -0600
Received: from [208.187.158.94] (helo=[172.16.1.29])
	by in01.mta.xmission.com with esmtpsa (TLSv1:AES256-SHA:256)
	(Exim 4.69) (envelope-from <robjsargent@gmail.com>)
	id 1MYMvy-0001jv-6Q; Tue, 04 Aug 2009 10:32:19 -0600
Message-ID: <4A78628D.7070503@gmail.com>
Date: Tue, 04 Aug 2009 10:32:13 -0600
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Thunderbird 2.0.0.22 (X11/20090608)
MIME-Version: 1.0
To: Venkateswara Rao Bondada <Venkateswara_B@infosys.com>
CC: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
References: 
 <22640DE58AF78445BA8AB69FF76F07321AA2C20BAB@BLRKECMBX01.ad.infosys.com>
	<4A775E91.4090608@gmail.com>
	<22640DE58AF78445BA8AB69FF76F07321AA2C2100A@BLRKECMBX01.ad.infosys.com>
In-Reply-To: 
 <22640DE58AF78445BA8AB69FF76F07321AA2C2100A@BLRKECMBX01.ad.infosys.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-XM-SPF: eid=; ; ; mid=; ; ; hst=in01.mta.xmission.com; ; ;
 ip=208.187.158.94;
	; ; frm=robjsargent@gmail.com; ; ; spf=neutral
X-SA-Exim-Connect-IP: 208.187.158.94
X-SA-Exim-Rcpt-To: Venkateswara_B@infosys.com, pgsql-sql@postgresql.org,
	robjsargent@gmail.com
X-SA-Exim-Mail-From: robjsargent@gmail.com
X-Spam-DCC: XMission; sa01 1397; Body=1 Fuz1=1 Fuz2=1 
X-Spam-Combo: ;Venkateswara Rao Bondada <Venkateswara_B@infosys.com>
X-Spam-Relay-Country: 
Subject: Re: Create table command fails with permission denied
X-SA-Exim-Version: 4.2.1 (built Thu, 25 Oct 2007 00:26:12 +0000)
X-SA-Exim-Scanned: Yes (on in01.mta.xmission.com)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.145 tagged_above=-10 required=5 tests=AWL=1.454,
	BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 200908/13
X-Sequence-Number: 32922

Moderately curious.

I wonder if 'cms' is on a different tablespace? Are there tables in that db?

Btw, I don't have 7.4 so I'm only guessing based on 8.3

rjs



Venkateswara Rao Bondada wrote:
> Hi Rob,
> 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. As postgres user, I granted CREATE, USAGE & ALL privileges to postgres account, still it didn't work.
> Please find the snapshots below where it works fine and also where it doesn't work fine. And let me know what rights postgres account is missing to create tables in "cms" database.
>
> ==========================================
> camd=# \c camd postgres
> You are now connected to database "camd" as user "postgres".
> camd=# create table test(id character varying(80));
> CREATE TABLE
> camd=# \c cms postgres
> You are now connected to database "cms" as user "postgres".
> cms=# create table test(id character varying(80));
> ERROR:  could not create relation "test": Permission denied
> cms=#
> ==========================================
>
> Thanks,
> Venkat
>
>
> -----Original Message-----
> From: Rob Sargent [mailto:robjsargent@gmail.com] 
> Sent: Tuesday, August 04, 2009 3:33 AM
> To: Venkateswara Rao Bondada
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] Create table command fails with permission denied
>
> Looks to me as though you are not the owner of the schema nor superuser 
> nor in a role with permission to create tables in said schema. See the 
> DBA if it's not you. If it is sign on as postgres (superuser) and grant 
> yourself some access rights.
>
>
>
> 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
>>
>>     
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
> for the use of the addressee(s). If you are not the intended recipient, please 
> notify the sender by e-mail and delete the original message. Further, you are not 
> to copy, disclose, or distribute this e-mail or its contents to any other person and 
> any such actions are unlawful. This e-mail may contain viruses. Infosys has taken 
> every reasonable precaution to minimize this risk, but is not liable for any damage 
> you may sustain as a result of any virus in this e-mail. You should carry out your 
> own virus checks before opening the e-mail or attachment. Infosys reserves the 
> right to monitor and review the content of all messages sent to or from this e-mail 
> address. Messages sent to or from this e-mail address may be stored on the 
> Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>   



From tgl@sss.pgh.pa.us Wed Aug  5 01:16:18 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 0283F633BC8
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue,  4 Aug 2009 22:16:18 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 79375-07 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed,  5 Aug 2009 01:15:59 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by mail.postgresql.org (Postfix) with ESMTP id 3C494632E8E
	for <pgsql-sql@postgresql.org>; Tue,  4 Aug 2009 22:16:07 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id n751G2dB025960;
	Tue, 4 Aug 2009 21:16:03 -0400 (EDT)
To: Venkateswara Rao Bondada <Venkateswara_B@infosys.com>
cc: Rob Sargent <robjsargent@gmail.com>,
	"pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Re: Create table command fails with permission denied 
In-reply-to: 
 <22640DE58AF78445BA8AB69FF76F07321AA2C2100A@BLRKECMBX01.ad.infosys.com>
References: 
 <22640DE58AF78445BA8AB69FF76F07321AA2C20BAB@BLRKECMBX01.ad.infosys.com>
	<4A775E91.4090608@gmail.com>
	<22640DE58AF78445BA8AB69FF76F07321AA2C2100A@BLRKECMBX01.ad.infosys.com>
Comments: In-reply-to Venkateswara Rao Bondada <Venkateswara_B@infosys.com>
	message dated "Tue, 04 Aug 2009 13:41:29 +0530"
Date: Tue, 04 Aug 2009 21:16:02 -0400
Message-ID: <25959.1249434962@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.271 tagged_above=-10 required=5 tests=AWL=1.328,
	BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 200908/15
X-Sequence-Number: 32924

Venkateswara Rao Bondada <Venkateswara_B@infosys.com> writes:
> camd=# \c cms postgres
> You are now connected to database "cms" as user "postgres".
> cms=# create table test(id character varying(80));
> ERROR:  could not create relation "test": Permission denied

Actually, what that is complaining about is that the operating system
refused its attempt to create a filesystem file to hold the table.
It's got nothing to do with permissions inside the database --- there
is something wrong with the filesystem permissions of the data
directory.  Or maybe you started the postmaster as the wrong user
(not the one that owns the data directory).

			regards, tom lane



From Venkateswara_B@infosys.com Wed Aug  5 17:21:20 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 42E006341C3
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed,  5 Aug 2009 14:21:20 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 39381-10 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed,  5 Aug 2009 17:21:07 +0000 (UTC)
Received: from mx3.hub.org (mx3.hub.org [206.223.169.73])
	by mail.postgresql.org (Postfix) with ESMTP id 9CCE0632842
	for <pgsql-sql@postgresql.org>; Wed,  5 Aug 2009 14:21:09 -0300 (ADT)
X-Greylist: delayed 00:07:10.301382 by SQLgrey-1.7.6
Received: from kecgate02.infosys.com (kecgate02.infosysconsulting.com
	[61.95.162.76]) by mx3.hub.org (Postfix) with ESMTP id B01F137B4E3
	for <pgsql-sql@postgresql.org>; Wed,  5 Aug 2009 14:13:20 -0300 (ADT)
X-TM-IMSS-Message-ID: <04575894000604e4@kecgate02.infosys.com>
Received: from blrkechub01.ad.infosys.com ([10.66.236.41]) by
	kecgate02.infosys.com ([61.95.162.76]) with ESMTP (TREND IMSS
	SMTP Service 7.0) id 04575894000604e4 ;
	Wed, 5 Aug 2009 22:33:42 +0530
Received: from BLRKECMBX01.ad.infosys.com ([10.66.236.21]) by
	blrkechub01.ad.infosys.com ([10.66.236.41]) with mapi; Wed, 5 Aug 2009
	22:35:56 +0530
From: Venkateswara Rao Bondada <Venkateswara_B@infosys.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: Rob Sargent <robjsargent@gmail.com>, "pgsql-sql@postgresql.org"
	<pgsql-sql@postgresql.org>
Date: Wed, 5 Aug 2009 22:35:54 +0530
Subject: Re: Create table command fails with permission denied 
Thread-Topic: [SQL] Create table command fails with permission denied 
Thread-Index: AcoVak+9AD8yCA/KQ6SlVOYzPiLc6QAhA9MA
Message-ID: 
 <22640DE58AF78445BA8AB69FF76F07321AA2D51550@BLRKECMBX01.ad.infosys.com>
References: 
 <22640DE58AF78445BA8AB69FF76F07321AA2C20BAB@BLRKECMBX01.ad.infosys.com>
	<4A775E91.4090608@gmail.com>
	<22640DE58AF78445BA8AB69FF76F07321AA2C2100A@BLRKECMBX01.ad.infosys.com>
	<25959.1249434962@sss.pgh.pa.us>
In-Reply-To: <25959.1249434962@sss.pgh.pa.us>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 200908/19
X-Sequence-Number: 32928

Hi Tom,
Thanks a lot. What you suspected is correct. Permissions are modified on th=
e underlying OS directory of this database. Once the permissions are rectif=
ied, I'm able to create tables without any issues.

Thanks to all for your support.

Venkat

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20
Sent: Wednesday, August 05, 2009 6:46 AM
To: Venkateswara Rao Bondada
Cc: Rob Sargent; pgsql-sql@postgresql.org
Subject: Re: [SQL] Create table command fails with permission denied=20

Venkateswara Rao Bondada <Venkateswara_B@infosys.com> writes:
> camd=3D# \c cms postgres
> You are now connected to database "cms" as user "postgres".
> cms=3D# create table test(id character varying(80));
> ERROR:  could not create relation "test": Permission denied

Actually, what that is complaining about is that the operating system
refused its attempt to create a filesystem file to hold the table.
It's got nothing to do with permissions inside the database --- there
is something wrong with the filesystem permissions of the data
directory.  Or maybe you started the postmaster as the wrong user
(not the one that owns the data directory).

			regards, tom lane