/postgres_privileges

Here is a document as guide for permissions in role group or users in postgresSQL