How to find out about user rights

Hi all:

I have just started to work with SQL, so maybe the answer to my question is really simple - but I can't find the answer to it in my books or in Google.

Is it possible to get a list of all tables within a database for which a certain user has rights? Of course, I could look through the table list in pgAdmin - but maybe there is something easier?

Or - another question - how could you possibly copy the rights of a certain user and assign them to another user?

Maybe some background information is helpful. I have two users working with the same topic - one has update, insert, delete-rights for several tables, the other has only select-rights. But there is no complete list. So I either have to find out all the tables for which the first user has update, insert, delete-rights (and then grant those rights to the second user) or I have to copy all the rights of the first user and assign them to the second. But I couldn't find information on how to do this. Can you help me?

Thanks in advance.

Annegret

---
Annegret Sauer
Universität Hohenheim
Kommunikations-, Informations- und Medienzentrum (630)
IT-Dienste | Verwaltungssysteme

Schloss Westhof-Ost | 70599 Stuttgart
Tel.: +49 711 459-23381 | Fax: +49 711 459-24224
Email: sauer(at)verwaltung(dot)uni-hohenheim(dot)de
https://kim.uni-hohenheim.de