Jason Hihn <jhihn(at)paytimepayroll(dot)com> writes:
> 2) Finding out what databases the user has access to (How?) without having
> to maintain a copy myself. (Can it be pulled from some system table, or join
> of system tables? (i.e. SELECT db_name FROM something WHERE user='me' AND
> granted_perm='SELECT')
I'm afraid not --- that info is only available from the postmaster's
pg_hba.conf file, which is not accessible as a table. The typical setup
though is that any user can connect to any database.
regards, tom lane