revoke/grant rights issue

From: "svn" <svngo(at)earthlink(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: revoke/grant rights issue
Date: 1999-12-29 18:14:55
Message-ID: 84dmhs$lmu$1@oak.prod.itd.earthlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Can someone direct me as to why the rights that I specify for a given table
doesn't take affect? I revoked all rights to the "Public" and the postgres
default id "nobody" can still do inserts, deletes, updates, etc. I do a \z
on the table and it shows no rights, but still allows anyone w/ a valid
postgres id to wipe out any row they wish. I've even tried to manually
revoke the rights from "nobody" and it still doesn't work. Are there
setting some where that "turns on" the specified privileges intiated by the
revoke/grant commands?

Thanks in advance.....

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-12-29 19:07:32 Re: [HACKERS] Index corruption
Previous Message Tom Lane 1999-12-29 16:07:26 Re: subquery performance and EXISTS