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
toit 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
lookthrough 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-rightsfor several tables, the other has only select-rights. But there is no complete list. So I either have to
findout all the tables for which the first user has update, insert, delete-rights (and then grant those rights to the
seconduser) or I have to copy all the rights of the first user and assign them to the second. But I couldn't find
informationon 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@verwaltung.uni-hohenheim.de
https://kim.uni-hohenheim.de