grant/revoke rights

From: "svn" <svngo(at)earthlink(dot)net>
To: pgsql-questions(at)postgresql(dot)org
Subject: grant/revoke rights
Date: 2000-01-04 19:42:29
Message-ID: F2sc4.5168$Ec5.265658@newsread1.prod.itd.earthlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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-general by date

  From Date Subject
Next Message Bruce Momjian 2000-01-04 19:43:45 Re: [GENERAL] \di won't display indexes
Previous Message Bruce Momjian 2000-01-04 19:39:17 Re: [GENERAL]disk size