Received: from donald.wipinfo.soft.net ([164.164.67.20]) by hub.org (8.8.8/8.7.5) with SMTP id XAA10987 for ; Wed, 29 Jul 1998 23:38:54 -0400 (EDT) Received: from apollo.wipinfo.soft.net by donald.wipinfo.soft.net (SMI-8.6/SMI-SVR4) id JAA05542; Thu, 30 Jul 1998 09:11:06 -0500 Received: from wipdisc.wipinfo.soft.net by apollo.wipinfo.soft.net (SMI-8.6/SMI-SVR4) id IAA10658; Thu, 30 Jul 1998 08:58:46 -0500 Received: from localhost by wipdisc.wipinfo.soft.net (SMI-8.6/SMI-SVR4) id JAA26067; Thu, 30 Jul 1998 09:09:03 -0500 Date: Thu, 30 Jul 1998 09:09:03 -0500 (GMT) From: "G.Elangovan " X-Sender: elangog@wipdisc To: James Olin Oden cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Problem in Grant and Revoke Query In-Reply-To: <81Jul28.065247edt.35713@gateway.lee.k12.nc.us> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Let me explain the exact scenario My project group owns the database ownership, as a project member i am having permission to createuser , createdatabase and destroy(user and database). I tested the database in this way database name is : mydb table name is : ptable database owner is : project-team query is : revoke all on ptable from public revoke all on ptable from group and similraly for grant query my query is to grant and revoke permission on "ptable" as owner (project-team) and access thro my user account. I am able to access database thro my account Problem is The grant and revoke is not working as expected. I hope u got the exact idea about my problem Thanku for ur reply and expecting friendship from u + reply for this On Wed, 29 Jul 1998, James Olin Oden wrote: > > > 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 > > > >