X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6EE37329CD2 for ; Fri, 17 Sep 2004 12:17:50 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18789-09 for ; Fri, 17 Sep 2004 11:17:44 +0000 (GMT) Received: from perseus.aganp.go.gov.br (perseus.aganp.go.gov.br [200.178.249.136]) by svr1.postgresql.org (Postfix) with SMTP id AB3F1329CB7 for ; Fri, 17 Sep 2004 12:17:43 +0100 (BST) Received: (qmail 49176 invoked by uid 98); 17 Sep 2004 11:17:40 -0000 Received: from 200.178.249.132 by perseus.aganp.go.gov.br (envelope-from , uid 1002) with qmail-scanner-1.23 (clamdscan: 0.75.1. Clear:RC:1(200.178.249.132):. Processed in 0.066247 secs); 17 Sep 2004 11:17:40 -0000 Received: from tomahawk.aganp.go.gov.br (HELO AGA253DISUP012) (200.178.249.132) by perseus.aganp.go.gov.br with SMTP; 17 Sep 2004 11:17:39 -0000 Reply-To: From: "Maximiliano Araujo Pedatella" To: Subject: RES: Revoke owner's privilege on the table Date: Fri, 17 Sep 2004 08:17:46 -0300 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 In-reply-to: <13525.1095376038@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/156 X-Sequence-Number: 14859 Jonh is really a superuser. Then, for this reason, cannot I revoke your privilege in the referred table? Maximiliano A. Pedatella Fone: +55 (62) 201-6571 Fax : +55 (62) 201-6573 mailto:maxp@administracao.go.gov.br -----Mensagem original----- De: Tom Lane [mailto:tgl@sss.pgh.pa.us] Enviada em: quinta-feira, 16 de setembro de 2004 20:07 Para: maxp@administracao.go.gov.br Cc: pgsql-admin@postgresql.org Assunto: Re: [ADMIN] Revoke owner's privilege on the table "Maximiliano Araujo Pedatella" writes: > Does anybody know as I do to revoke the privilege of the user owner of a > certain table, because the command, for example, "REVOKE ALL ON TABLE test > FROM jonh;" is not working? Perhaps jonh is a superuser? regards, tom lane