grant all on schema to user postgres code example Example: user privileges postgresql information_schema GRANT SELECT ON ALL TABLES IN SCHEMA PUBLIC TO testuser2;