[BUGS] GRANT SELECT ON ... TO username does REVOKE ALL ON ... FROM PUBLIC at the same time

2001-05-31 Thread pgsql-bugs
Jean-Francois Leveque ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description GRANT SELECT ON ... TO username does REVOKE ALL ON ... FROM PUBLIC at the same time Long Description System: SuSE 7.0 PostgreSQL RPM: postgres-7.0.2-29 sele

Re: [BUGS] REVOKE ... FROM username equals REVOKE ... FROM PUBLIC

2001-05-31 Thread Tom Lane
[EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 4:

[BUGS] REVOKE ... FROM username equals REVOKE ... FROM PUBLIC

2001-05-31 Thread pgsql-bugs
Jean-Francois Leveque ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description REVOKE ... FROM username equals REVOKE ... FROM PUBLIC Long Description System: SuSE 7.0 PostgreSQL RPM: postgres-7.0.2-29 select version(); : PostgreSQL 7.0