Postgres Pro
Downloads
Home   >   mailing lists

Re: REVOKE ... FROM username equals REVOKE ... FROM PUBLIC - Mailing list pgsql-bugs

From Tom Lane
Subject Re: REVOKE ... FROM username equals REVOKE ... FROM PUBLIC
Date
Msg-id 10668.991319100@sss.pgh.pa.us
Whole thread Raw
In response to REVOKE ... FROM username equals REVOKE ... FROM PUBLIC  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
pgsql-bugs@postgresql.org writes:
> When I revoke select from a user, it revokes select from other
> users, database object owner included.

No, only from the owner.  Update to 7.1.

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: REVOKE ... FROM username equals REVOKE ... FROM PUBLIC
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: GRANT SELECT ON ... TO username does REVOKE ALL ON ... FROM PUBLIC at the same time