Received: from lee.k12.nc.us (mail.lee.k12.nc.us [207.4.71.118]) by hub.org (8.8.8/8.7.5) with ESMTP id IAA06523 for ; Wed, 29 Jul 1998 08:00:34 -0400 (EDT) Received: by gateway.lee.k12.nc.us id <35713>; Tue, 28 Jul 1981 06:52:47 -0400 Date: Wed, 29 Jul 1998 08:02:31 -0400 From: James Olin Oden X-Mailer: Mozilla 4.04 [en] (Win95; I) MIME-Version: 1.0 To: root CC: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Problem in Grant and Revoke Query References: <35BEF04A.3374BA2@wipinfo.soft.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-Id: <81Jul28.065247edt.35713@gateway.lee.k12.nc.us> > Hi > I am not able to set permission using Grant and Revoke > I tried t o revoke all permission from a table , but unfortunately > other users are able to make query on the table > Please give me more details on Grant and Revoke usage with few examples > Two questons: 1) Who owns the database in which you revoked the privlidges? Is that user the one you were logged in as when you revoked the privlidges. 2) Could you send the exact SQL statement you typed to do this? Perhaps there is something wrong in it. ...james > Thanku