Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 998E92E0048
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Fri, 13 Jun 2008 10:35:12 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 70098-05
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Fri, 13 Jun 2008 10:35:03 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.155])
	by developer.postgresql.org (Postfix) with ESMTP id 2A35F2E0091
	for <pgsql-admin@postgresql.org>; Fri, 13 Jun 2008 10:35:08 -0300 (ADT)
Received: by fg-out-1718.google.com with SMTP id 16so3062562fgg.23
	for <pgsql-admin@postgresql.org>; Fri, 13 Jun 2008 06:35:07 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:mime-version:content-type;
	bh=sOnKTJv2lCqqM5rZH2IcUE7tMabZykv/Ke/C5j++D6A=;
	b=LvSSK8ef6Fw18LpGDvj5NITfB+3beVHsTfNyc2jlnhhW2f6KSC/G79xTIx0EuJVDZD
	xtrR3m2PT9FwzvdOvAuuk4dE/NYaCYcbIfewr+NJs0THm2lIHOnXqTQuqRfYuG4fdzAi
	CkeQbjRm2OgcaFUeMfuOJ+vWvSCFjUY0Zdbsc=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=qTZrWkky+y7Y0PbT0nLDJ0yxbuiaDM9/0DJuKR5n8x0WOfkV7vqdMaj2C1u0sbbH/R
	3WrjKjFZBv1z1XqpRjVIQ0wc6TB3W1KkCFqdHfgUHzFCSIsBx58OscW3pEie7/Yhmzje
	CYeeSHZ2q0gsHHLkVaxeZUFY6HVnyOv6O0s9o=
Received: by 10.86.68.20 with SMTP id q20mr4015375fga.2.1213364106945;
	Fri, 13 Jun 2008 06:35:06 -0700 (PDT)
Received: by 10.86.36.13 with HTTP; Fri, 13 Jun 2008 06:35:06 -0700 (PDT)
Message-ID: <3a0028490806130635v2a0890easf8c22b8362d06e89@mail.gmail.com>
Date: Fri, 13 Jun 2008 10:35:06 -0300
From: "Rafael Domiciano" <rafael.domiciano@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Revoke for a new role
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_16655_33437305.1213364106931"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.951 tagged_above=0 required=5 tests=AWL=0.950,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200806/108
X-Sequence-Number: 29446

------=_Part_16655_33437305.1213364106931
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi folks,

I'm new in this mailing list.

I need to create a role (Postgres user) that cannot drop or create table,
but can create TEMP tables. This role must do I, U and D normally.

I have read some docs over the web and discovered that option to revoke
"create table" doesn't exist.

Can someone give me a light?!

Thnks

Rafael Domiciano
Senffnet Ltda.
DBA Postgres

------=_Part_16655_33437305.1213364106931
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi folks,<br><br>I&#39;m new in this mailing list.<br><br>I need to create a role (Postgres user) that cannot drop or create table, but can create TEMP tables. This role must do I, U and D normally.<br><br>I have read some docs over the web and discovered that option to revoke &quot;create table&quot; doesn&#39;t exist.<br>
<br>Can someone give me a light?!<br><br>Thnks<br><br>Rafael Domiciano<br>Senffnet Ltda.<br>DBA Postgres<br>

------=_Part_16655_33437305.1213364106931--