This post will explain how the PostgreSQL privilege system works and how to see the current ACLs for various objects.