hi, why when i revoke all on scheme pg_catalog from all (with public) i can make select from pg_ tables and views as ordinary user ?? I can usage this scheme so why i can makeing select ?
Then i remove SELECT perm from PUBLIC on pg_ tables and then i cant makeing select from this tables , but i can make select from views, even i dont have perm to do select from src tables of thises views. what do you this about using RE in select , or only rel names like : revoke all on table pg_* from public ? etc ? and how disallow : LISTEN , SET , RESET , and SHOW ? bye iv ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html