X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 3107D9FA6B2 for ; Wed, 26 Jul 2006 10:49:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 72447-04 for ; Wed, 26 Jul 2006 10:49:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.zanthus.com.br (mail.zanthus.com.br [200.212.65.85]) by postgresql.org (Postfix) with ESMTP id CF9499FA666 for ; Wed, 26 Jul 2006 10:49:41 -0300 (ADT) Received: from cprsakai (unknown [192.168.0.71]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by mail.zanthus.com.br (Postfix) with ESMTP id 311A5241B1 for ; Wed, 26 Jul 2006 10:51:27 -0300 (BRT) Reply-To: From: "Rodrigo Sakai" To: Subject: ROLES and PRIVILEGES Date: Wed, 26 Jul 2006 10:50:48 -0300 Organization: Zanthus Message-ID: <002901c6b0ba$805f6960$4700a8c0@TREEZANTHUS> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002A_01C6B0A1.5B147B50" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807 Thread-Index: AcawuoAt9f4na2YjQ56cKXrWsU+cVA== X-Zanthus-MailScanner: Found to be clean X-Zanthus-MailScanner-From: rodrigo.sakai@zanthus.com.br X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200607/220 X-Sequence-Number: 22466 This is a multi-part message in MIME format. ------=_NextPart_000_002A_01C6B0A1.5B147B50 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi all, Sorry if this is an already answered question. I'm having some troubles to set privileges to a user (role). I have to roles, postgres (the superuser) and roger, I created a database 'test' with postgres role and I want that roger have only SELECT, INSERT, UPDATE and DELETE on that database, so I tried: REVOKE ALL ON DATABASE test FROM roger; GRANT SELECT, UPDATE, INSERT, DELETE ON TO roger; But the role roger can still create objects in this database and I don't want it! Any HELP??? Thanks!!! Rodrigo Sakai Administrador de Banco de Dados *(11) 3750-7075 * rodrigo.sakai@zanthus.com.br ------=_NextPart_000_002A_01C6B0A1.5B147B50 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

 

  Hi all,

 

  Sorry if this is an already answered = question. I’m having some troubles to set privileges to a user (role). I have to = roles, postgres (the superuser) and roger, I created a database = ‘test’ with postgres role and I want that roger have only SELECT, INSERT, UPDATE and = DELETE on that database, so I tried:

 

  REVOKE ALL ON DATABASE test FROM = roger;

 

  GRANT SELECT, UPDATE, INSERT, DELETE ON = <table_name> TO roger;

 

  But the role roger can still create = objects in this database and I don’t want it!

 

  Any = HELP???

 

  Thanks!!!

 

 

 

 

 

Rodrigo = Sakai

Administrador de Banco de = Dados

É(11) = 3750-7075

* rodrigo.sakai@zanthus.com.br=

 

 

------=_NextPart_000_002A_01C6B0A1.5B147B50--