Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 94F2B9FB593 for ; Thu, 26 Jul 2007 23:41:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 13919-05 for ; Thu, 26 Jul 2007 23:41:15 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.232]) by postgresql.org (Postfix) with ESMTP id A07989FB525 for ; Thu, 26 Jul 2007 23:41:14 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id l8so582124nzf for ; Thu, 26 Jul 2007 19:41:12 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=fNaMTffsI5FR1XpNaeDil6/cH5BbZwizL26OqcJHmnigByr6fZb2ksYbpUrqiKvHA3Zn7jBGBzFXbE1yWJcHvj61iWWefTbJrppu3FFvKgpvvP36TmVoWHQSv/MqqGXjAuY+qAFKglavtzHUpB3hioyCQs1P3CFSGLVRKw/0Aiw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Q+m0Ydfctm0JCqQ2cnWu/u9OQgMhoo9ExGJXigoHbhi/lBl/FAPgHFRfKqI2KcAGBkoJ54X+UOkOg01qCWqa9apfU3m+xY/lCY4aEcAayFvOuCnoNgLl+y1QAwVRzJwhZWu3Vthjo5X39wcWO3KE8kwCqFDajdi56wSfkfCHEH8= Received: by 10.115.32.1 with SMTP id k1mr2432419waj.1185504072206; Thu, 26 Jul 2007 19:41:12 -0700 (PDT) Received: by 10.114.144.2 with HTTP; Thu, 26 Jul 2007 19:41:12 -0700 (PDT) Message-ID: <1c66bda80707261941s78aa820dh2abeb49a39e39c46@mail.gmail.com> Date: Fri, 27 Jul 2007 14:41:12 +1200 From: adey To: "Anderson Alves de Albuquerque" Subject: Re: No create table Cc: pgsql-admin@postgresql.org In-Reply-To: <9b3f75f0707260856u66b37b91w5a842f6d0b6dc6ec@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_100804_5105721.1185504072170" References: <9b3f75f0707260856u66b37b91w5a842f6d0b6dc6ec@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/300 X-Sequence-Number: 26281 ------=_Part_100804_5105721.1185504072170 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Did your cammand fail, or did it work, but the user can still create tables? On 7/27/07, Anderson Alves de Albuquerque wrote: > > > I need to use a user that can not have permission to create table in one > BD. > > I use revoke, I tray with "revoke all on database XXX to|from > USERNAME;", but I don't have success. > > Could someone help me? > > With revoke I only limit access in tables. > > ------=_Part_100804_5105721.1185504072170 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Did your cammand fail, or did it work, but the user can still create tables?

On 7/27/07, Anderson Alves de Albuquerque <andersonaa@gmail.com> wrote:
 
 I need to use a user that can not have permission to create table in one BD.
 
 I use revoke,  I tray with "revoke all on database XXX to|from USERNAME;", but I don't have success.
 
 Could someone help me?

 With revoke I only limit access in tables.

 

------=_Part_100804_5105721.1185504072170--