Horton

Re: Permissions not working

Peter Eisentraut <peter_e@gmx.net>

View thread View on postgr.es
From: Peter Eisentraut <peter_e@gmx.net>
To: Pallav Kalva <pkalva@deg.cc>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: "scott.marlowe" <scott.marlowe@ihs.com>, pgsql-sql@postgresql.org
Date: 2004-05-01T21:13:45Z
Lists: pgsql-sql 
Pallav Kalva wrote:
> Also here is the privileges information from information_schema
> tables. Is there a way to REVOKE these
> privileges ?

You need to log in as the user that has granted the privilege you want 
to revoke.  In this case, log in as postgres and do REVOKE ALL FROM 
PUBLIC;.