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 seeing objects way.

you can experiment revoking privileges on system catalog tables this:

revoke select on pg_catalog.pg_class public; 

which keep people seeing tables in database.

this should keep database functional, cause errors in client programs psql expect able read these tables.