Re: [SQL] Problem in Grant and Revoke Query

From: James Olin Oden <joden(at)lee(dot)k12(dot)nc(dot)us>
To: root <elangog(at)wipinfo(dot)soft(dot)net>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Problem in Grant and Revoke Query
Date: 1998-07-29 12:02:31
Message-ID: 81Jul28.065247edt.35713@gateway.lee.k12.nc.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql


> 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Marcio Macedo 1998-07-29 15:14:43 Money Type question
Previous Message root 1998-07-29 09:50:02 Problem in Grant and Revoke Query