Joakim Bomelin <jbm@gronaverket.se> writes:
> In MySQL I am able to set privileges on databases so user Ben can't
> access user Stephen's database, but I can't work that out in pgsql. Is
> it just me, or is GRANT only working for tables?
If you don't want Ben to get into Stephen's database at all, set up
connection permissions (pg_hba.conf) to prevent it. GRANT only operates
within a database, it does not control connection permissions.
regards, tom lane