postgresql - Postgres user sees all schemas/tables -
when create new user database without rights, new user can still see schemas/tables etc. can't access them, still sees them. revoke these privileges, not know how. this how created user: create user wouter_test password 'wouter_test' nosuperuser nocreatedb nocreaterole nocreateuser inherit; based on post thought may have rights users have public schema , information public schema contains: https://dba.stackexchange.com/questions/98892/minimal-grants-for-readonly-single-table-access-on-postgresql based on wikisite: https://wiki.postgresql.org/wiki/shared_database_hosting used command revoke on schema public wouter_test; it did not work. following did not seem work either (to prevent user seeing , accessing database called klm ) revoke connect on database klm wouter_test; but still user, in pgadmin, can see databases, schemas , tables (including klm ). what doing wrong? you can revoke ... public forbid users use object, cannot keep user se