Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id D0D1A9FB4F1 for ; Thu, 26 Jul 2007 12:56:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 87572-05 for ; Thu, 26 Jul 2007 12:56:37 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.227]) by postgresql.org (Postfix) with ESMTP id B5BE99FA29C for ; Thu, 26 Jul 2007 12:56:43 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 68so358336wri for ; Thu, 26 Jul 2007 08:56:43 -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:mime-version:content-type; b=XXzJ5QQWLtEZMx04ckYLO+FKRwKeFhw+ZwAu18bvZTzwXOds89IJZrI07J8DdRf6MgQ9BKxbcOpgLjmvwKL5e5hLc9LAWfBJfYEcZXRr1mnuEPaDJr6dBUhayjypg2G3VgLAXDm4mXWi8YMg40mMsmb880L1mR9fgPtKyiPWP2Q= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=ADv0pso6j+qSjo/6tCwpq6LfDGXPuqzRxbIQ6yQGRUMW6LuN7TK+xQZkl8be8K9fdNQAlZ6l3CzoP+tqax5XfSNqDnU+F7x7chCezEEtlatLJj6Z9k4No4bbRTvTh0eujr81ouKd2YW5RlJLPvfXHyRW7H0I4dqSmVGjF8PWnrE= Received: by 10.100.126.2 with SMTP id y2mr1507630anc.1185465402860; Thu, 26 Jul 2007 08:56:42 -0700 (PDT) Received: by 10.100.191.10 with HTTP; Thu, 26 Jul 2007 08:56:42 -0700 (PDT) Message-ID: <9b3f75f0707260856u66b37b91w5a842f6d0b6dc6ec@mail.gmail.com> Date: Thu, 26 Jul 2007 12:56:42 -0300 From: "Anderson Alves de Albuquerque " To: pgsql-admin@postgresql.org Subject: No create table MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_186446_11714719.1185465402715" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200707/296 X-Sequence-Number: 26277 ------=_Part_186446_11714719.1185465402715 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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_186446_11714719.1185465402715 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
 
 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_186446_11714719.1185465402715--