Check access rights

In psql, list owners of all databases:

\l

List access privileges of one table:

\z myTable